Importing data using a Macro?

[Grace]

Hello, can I use a Macro to automatically import data from
an Excel spreadsheet into a temporary table. I am
assuming I would need to run VBA to do the import and then
have the macro run a query to append the data to from the
temp table to my other table.

Can anyone provide me with the code to ImportTables ()?

Thank you,
Grace

 

[Steve Schapel]

Grace,

See Help on the TransferSpreadsheet macro action.