Access Macro - Copy and rename table

[mk000]

Hi,

I have two tables, one named Old, one named new. Each table has the same structure. Each week I need to delete the contents of the new table. I then need to cut all the old table values and paste them into the new table.

Anyone know how I can do this with vba?

mk

 

[Joe4]

You can do it with a macro (which you can convert to VBA code if you like).

To delete the data out of the one table, just use a RunSQL Macro command with this line of code:

DELETE [Table1].* FROM [Table1]

(substituting in your table name).

Then, create an Append Query to copy all your data from the one table to the other. Then just use the OpenQuery Macro command to run that Append Query.