Output to Excel

  • Thread starter Thread starter jjacob
  • Start date Start date
J

jjacob

I am creating a macro that will run seveal select queries and output to
Excel. I'd like to have all the data end up as different sheets within the
Excel workbook. However, after setting up and testing a few lines in the
macro, access wants to delete and recreate the Excel file for each query. Is
there another command to have it insert into the Excel file?

TIA!
 
In the macro, you can write a line for each sheet in the workbook. Each would
be a TransferSpreadsheet. The Table Name would contain the table or query to
be exported, and all would contain the same name of the workbook.xls.

Each shoud appear as a separate sheet in the workbook.
 
Back
Top