Exporting an access query to a excel template

J

Jack

Hi,
I have a access parameterized query which when run yeilds result sets. I
have a excel template where the number of columns and order are same as the
output of the access query result. This output when copied and pasted to the
excel template manually provides correct result. However, I need to automate
this process. I need to have button on a form which when clicked would run
the parameterized query and output to the excel template. I would appreciate
any links to article/help to resolve this issue. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Export Data from Report or Query to Excel 1
Access 2003 to Excel 2003 Q's 2
Error Exporting To Excel 1
Exporting to a template 1
Output to : Template file 3
Error Exporting Access Query Results to Excel 1
expoerting data to excel 1

Top