Combine 5 imported tables to one

[Barrow66]

Hi All,

Mr.Big helped me out shortly. However, I have to insert data from five tables already imported into Access97 database into one table. I have written 5 seperate modules to do the load.It worked but took a longer time to load than I expected because I have 565650 records.
Can someone please show me a code that will incorporate inserting all records from the 5 table into one table,by only using one module instead of 5 seperate modules.Column names are the same for all tables.

 

[grnzbra]

Sounds like a union query driving an append query would do the trick

 

[gusbrunston]

Hi:

I use a delete query, followed by a maketable query. Gus Brunston An old PICKer, using Access2000.