On Mon, 15 Nov 2004 09:39:08 -0800, "Nikhil Natarajan" <Nikhil
I am trying to merge data from multiple tables into one large table. All of
the tables contain the same field titles. The only information I could find
involved linking tables or creating a mail merge. Any information would be
greatly appreciated.
Use an Append query. There's a lot of assistance in Help, here's the
Summary
Append query
Adds a group of records from one or more tables to the end of one or
more tables. For example, suppose that you acquire some new customers
and a database containing a table of information on those customers.
To avoid typing all this information in, you'd like to append it to
your Customers table. Append queries are also helpful for:
· Appending fields based on criteria. For example, you might
want to append only the names and addresses of customers with
outstanding orders.
· Appending records when some of the fields in one table don't
exist in the other table. For example, in the Northwind sample
database, the Customers table has 11 fields. Suppose that you want to
append records from another table that has fields that match 9 of the
11 fields in the Customers table. An append query will append the data
in the matching fields and ignore the others.
Cheers,
Brett
