Exporting to Excel

[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

 

[Ken Snell [MVP]]

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