Merging two tables from different databases

[Guest]

Hi,

Alrighty - here is the setup... I have two access databases (Address-Old
and Address-New). The Address-Old database has a table containing outdated
information and the Address-New database has a table with the updates.

I want to merge these two database tables together so that I do not have to
re-type 4400 records.

Ex. Smith is outdated in the OLD database table and has a new address in
the NEW database table. I want the updates to match on "Smith".

Thanks.

P.S. - These are in two different DB's cause the updates got farmed out, not
my decision...

 

[Jeff Boyce]

Are you absolutely certain you want all the "Smith" records in your
Address_1 table to be updated by whatever is in Address_2? "Smith" isn't a
particularly unique identifier.

If you were going to manually uniquely identify (and match) between the
tables, what field(s) would you use, and how would you decide "ties"?
That's how you'd have Access know which ones match.

Then (and only then) you could use an update query -- BACKUP, BACKUP, BACKUP
before you work with either db.

 

[Guest]

Alrighty - so Smith was a bad example. The identifier would need to be a
match between first and last name.

As for ties, I'd need a way to manage that. This is my problem.

I'd imagine I could write a script to do this using an UPDATE statement, but
I don't know how to set it up and what the actual script should be.

And of course - 5 different backups of each database have already been
planned.

 

[Jeff Boyce]

No script needed -- you only need to use an "update" query and join the two
tables on their common field(s).

By the way, "John Smith" is NOT UNIQUE EITHER! - I strongly recommend that
you confirm the uniqueness of the fields you intend to use before
proceeding.