Copying table data to other table

[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

 

[Sreedhar]

With Append Queries.

Design Append Queries for each of the six tables keeping the target table as
the same for all of them.

 

[Mark F.]

I wasn't quite sure how to create an append query. Once I knew what to
do, I found it in the help files. Worked perfectly and saved me a lot of
work. Thanks!

Mark