Exporting Data to One Excel Workbook to Several Worksheets

  • Thread starter Thread starter crmulle
  • Start date Start date
C

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,
 
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.
 
Thank you very much.

Ken Snell said:
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/
Click to expand...
 
Back
Top