Arvin: export to an existing excel file

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

Arvin,

Thank you for having responded to my previous questions!

Do you know how to export multiple tables to ONE excel
file on different tab? or export a table to an existing
excel file on a new tab (worksheet)?

Thank you very much!

Shirley
 
Use the TransferSpreadsheet action to do this. Specify the same EXCEL file
as the destination for each action (each table). ACCESS will put each new
object (table) onto a new worksheet in the 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

How to Export Gmail Emails to PST Format? 4
Exporting Data from access and appending to an existing excel sprd 3
Export to Excel 3
Export Records Into Existing Excel File 1
Exporting to Excel 4
something wrong with exporting to excel and replacing existing fil 2
Attn Arvin 5
Automating export to Excel 4

Back
Top