Import and Run macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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