Merging Two Access Databases

[jstonend]

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.

 

[DL]

Try posting to a specific Access ng
eg ms.public.access
Though if you created an access db with 4400 updated records why did'nt you
simply update the origonal, or a copy of same?