Hello,

I have two tables in Ms Access, which I want to export using VBA to an excel
workbook.

I know that I can export a table in Ms Access to an Excel workbook using the
command:
DoCmd.OutputTo acOutputTable, "Table_Name", acFormatXLS, "C:\myfile.xls"

Is there a method to export the second table to the same workbook on the
second worksheet? I have been able to do that only using some long method,
which is, opening the workbook, adding a worksheet, selecting it, looping
through the table's fields and writing them down to specific cells, and then
looping through the data in the table, all of which is manual, unlike the
code above.

Will appreciate any input,

Thanks!

Tj