Importing data using a Macro?

  • Thread starter Thread starter Grace
  • Start date Start date
G

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
 
Back
Top