Macro to Export

  • Thread starter Thread starter PA
  • Start date Start date
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
 
Paul,

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