Importing data using a Macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grace - 27 Feb 2004 16:55 GMT

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

Reply to this Message

Steve Schapel - 27 Feb 2004 19:01 GMT

Grace,

See Help on the TransferSpreadsheet macro action.

Signature

Steve Schapel, Microsoft Access MVP

> Hello, can I use a Macro to automatically import data from
> an Excel spreadsheet into a temporary table. I am
[quoted text clipped - 6 lines]
> Thank you,
> Grace

Reply to this Message