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]]

Jut repeat the process for the next table, using the same destination file.
The second table's data will go on a new worksheet in that file.