Exporting to Excel

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