Import and Run macro

A

Adam

I need to create a macro that will import an Excel file to a table with no modifications needed. It then has to delete a current table 'A' and rename the imported table to table 'A'. After that it need to run 3 queries in succession, Q1, Q2, Q3. I know how to have the macro run the 3 queries in succession, but I do not know how to do the rest

Please help
Thanks!!
 
K

Ken Snell

Here are the action steps (in order) that you'll need to run. I've not
filled in the arguments for each, but I think you'll find that they're
self-explanatory when you create the macro in design view window:


TransferSpreadsheet

DeleteObject

Rename

OpenQuery

OpenQuery

OpenQuery


--
Ken Snell
<MS ACCESS MVP>

Adam said:
I need to create a macro that will import an Excel file to a table with no
Click to expand...
modifications needed. It then has to delete a current table 'A' and rename
the imported table to table 'A'. After that it need to run 3 queries in
succession, Q1, Q2, Q3. I know how to have the macro run the 3 queries in
succession, but I do not know how to do the rest.
 
Top