Exporting to Excel

J

J. Trucking

Hello,

I am trying to export the results of a query to excel. I have tried
TransferSpreadsheet but I do not want it to automatically save the
spreadsheet. I simply would like excel to open (as Book1) and have
the data from the query be imported into the spreadsheet. I want the
user to have the ability to save if they want to or not. Is this
possible?

Thanks in advance,

John
 
S

Stockwell43

There are various ways and some of guys can point you in a direction of doing
it from a command button. However, The way I do it is to create a report from
my query and after I run the report, on the toolbar is and Anaylize with
Excel button. Click on that and it dumps the report into Excel so your user
can omdify it to their needs.
 

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

Export to Excel 3
export to excel and save 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Macro - Access 8
Automating export to Excel 4
passing params to multiple querydefs and transferspreadsheet 8
Exporting Query from Access 2007 to Excel 2007 4
Exporting to Excel from Access 3

Top