Macro to Export

[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

 

[Steve Schapel]

Paul,

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