compare and append tables

[Guest]

I would like to compare 2 tables (tbl1 and tbl2) and add the missing records
from tbl1 to tbl2. Is there an straight forward way of doing this?

regards

 

[Guest]

The easiest way to do this would be to create a new Unmatched Query. The
wizard can lead you through this. After you create the query change it from
a select query to an append query. You should find this fairly easy.

 

[John Vinson]

I would like to compare 2 tables (tbl1 and tbl2) and add the missing records
from tbl1 to tbl2. Is there an straight forward way of doing this?

regards

First, back up your database... just in case.

There are two ways to do this. If you have a Primary Key or a unique
index which would prevent addition of duplicate records, you can
simply create an Append query based on Tbl1 and append records to
tbl2. Any records missing from tbl2 will be added; records that are
already there will generate a (single) warning message and won't be
added.

If you don't have such an index, you can create an Unmatched query
using the query wizard, and turn it into an Append query. Post back if
this doesn't work as you expect!

John W. Vinson[MVP]