Export table to excel using excel template

[allenjasonbrown@gmail.com]

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?

[Rod]

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!