Exporting Data to One Excel Workbook to Several Worksheets

[crmulle]

I want to export several tables and queries from Access to one workbook with
several worksheets. Each of the tables is exported to a different tab within
the same Excel workbook. Can this be done?

Thank you,

 

[Ken Snell [MVP]]

Yes. Use the same filename each time you do the export via
TransferSpreadsheet. The query / table name that you are exporting will be
used as the name of the worksheet in the file.

See the webpage in my signature for various examples of EXCEL export code.

 

[crmulle]

Thank you very much.

Yes. Use the same filename each time you do the export via
TransferSpreadsheet. The query / table name that you are exporting will be
used as the name of the worksheet in the file.

See the webpage in my signature for various examples of EXCEL export code.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/