How to export different table to different sheet of 1 excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would appreciate insight if the captioned can be done using macro / VB coding
 
If you export a table or query to an existing EXCEL file using
TransferSpreadsheet (macro or VBA), and the first 31 characters of the table
or query do not match the name of any existing worksheet in that EXCEL file,
ACCESS will create a new worksheet in that file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing any excel files with any sheet name into different tables in MSAccess using code 0
How to Export Gmail Emails to PST Format? 4
Exporting pivot tables 2
Exporting pivot tables to excel 1
Access OLE Data to Excel 1
Word to Excel: Export comments with text and line number 0
Exporting Data to One Excel Workbook to Several Worksheets 2
Can I export from Access to Excel using field names not captions? 0

Back
Top