Macro to Export

P

PA

I would like to create a macro, using Access 2007, to Export a table named
tblSales in my DB named CustomerActivity. The target should be an Excel file.
The file is saved at H:\IncOrd and is named CustActivity.xlsx and the
target worksheet is A-09.
I am VBA illiterate so a macro would seem like the best bet.
Suggestions would be appreciated.

Thank you
Paul
 
S

Steve Schapel

Paul,

You can use either an OutputTo action or a TransferSpreadsheet action in
your macro.
 

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

Export table to txt file with a variable filename 0
export macro 1
export query to excel macro 4
Macro to Export Text 1
Need to export multiple files 3
Transfer Text, Export Delimited w/ Number formated to 4 decimals. 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Transfer Text Macro - How to stop macro if file isn't there 1

Top