Hello - I would like to export a table or query (using Access VBA) to excel 2007, using an excel template (for headings, formatting, totals, etc).
Is this possible?
Hello - I would like to export a table or query (using Access VBA) to excel 2007, using an excel template (for headings, formatting, totals, etc).
Is this possible?
Yes.
You can use Access to push the data to Excel or use Excel to pull the data. If you still want to know how, post back and I will help. It's many years since I last did this so I need to do some revision!