output to excel

H

HM

Greetings all,

I need help trying to automatically use excel with my Access 2000 query.
Right now I run a query and copy and paste data from the query to Excel.

Is there a way to make a command button to run my query "qry AU D" and
automatically open excel and paste the fields and titles into an Excel
worksheet?

Thanks in advanced,

Hanie
 
Top