Exporting an access query to a excel template

  • Thread starter Thread starter Jack
  • Start date Start date
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.
 
Back
Top