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.
 
Back
Top