Exporting to Excel

  • Thread starter Thread starter Winter Special
  • Start date Start date
W

Winter Special

I'm using the DoCmd.TransferSpreadsheet acExport,etc... to export a table to
excel. This gives me a spreadsheet with one worksheet.

Is there anyway to export more than one table to an excel file where each
table would have its own worksheet?

I'm using access 2000.

Thanks

Jack
 
Just repeat the TransferSpreadsheet action with another table, specifying
the same output file. A new worksheet will be created for that second table.
 
Back
Top