Merging table data

[Mark F.]

I have an Access 2000 database that contains six tables. They all
contain the same fields (Object, Name, Desc, CodeNo). I want to copy all
the data from each table into one big table in another database file
(mdb). Is that possible?

Thanks,
Mark

 

[bob]

Use a Union Query to create one table. Export the table.

Bob