Arvin: export to an existing excel file

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
 
K

Ken Snell

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.
 

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

Embed the same Excel multiple times 0
Images are pixelated when saving to PDF 0
VBA - exporting serial letters to single documents 0
Consolidation Table from Different Excel Tabs with Different Format 1
Export to Excel 3
Exporting Data from access and appending to an existing excel sprd 3
Sharing Excel 365 Mac<->PC 0
Insert name and adress from a list in a word document 1

Top