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
 

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

Embed the same Excel multiple times 0
Pasting a cell into bookmarked table from excel vba 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
filling a query in a external database from excel 2007 0
I need to cut characters off of a list of text cells... 2
Weird problem w/ Group Header 3
Automatically change cover image when text changes 0
Creating automatic reports in Excel using Access 1

Top