merging tables

[Guest]

I have two tables in an access database that I need to merge. Both tables
contain the same fields, such as first name, last name, etc. I want to merge
these two tables into one, containing all of the entries, not just the ones
that are equal. Can someone help?

 

[Brian]

I have two tables in an access database that I need to merge. Both tables
contain the same fields, such as first name, last name, etc. I want to merge
these two tables into one, containing all of the entries, not just the ones
that are equal. Can someone help?

Sound like you want an append query that takes all of the records from one
table and appends them to the other.

You can easily do this in the query design view. Create a query that
selects all the fields from one of the tables. On the "Query" menu, choose
"Append Query", and specify that you want to append the data to the other
table. Run the query.

This will NOT work if there are duplicate primary keys across the two
tables. If that is the case, what you need to do will depend on how,
logically, you want to resolve the duplicates.

 

[PC Datasheet]

Use an append query and append table2 into table1.