Hi,
I want to have a macro run in VBA
where I copy a MS Access table and rename it.

Essentially, the code goes as follows:

****************************

1. Do data manipulation
2. Delete table "Table1"
3. Copy table.
4. Rename table to "Table1"


**************

This code runs in a loop.

I could do it by using "Select/INTO" statements.
But I assume there's a faster and more effective method.


Also, the data manipulations are based on a query which is based on the
renamed table "Table1". Will the integrity hold up for each loop of the code.

Hi,

I´m not clear with Your situation.

Do You want a VBA-solution in Excel to do the job?

Yes, it is possible except for deleting a table.

Please let us know more about it.

Kind regards,
Dennis

Look at the help for the docmd object - there is a method called runmacro.