How do I merge 2 databases that have a number of duplicate enteries

[SLGTPA]

I have 2 databases that have approximately 9000 records each. The share a number of common fields. I need to move the addresses in the first database into the address field of the corresonding record in the second database. Thanks!

[DonRayner]

I have 2 databases that have approximately 9000 records each. The share a number of common fields. I need to move the addresses in the first database into the address field of the corresonding record in the second database. Thanks!

I would do it in vba using dao recordsets.

[NeoPa]

1. Do you mean databases or tables?
2. What determines "correspond ing" in your scenario?

[NeoPa]

This will work much better if you can post the meta-data (info about the layout / structure) of the table in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used. PK & FK stand for Primary Key & Foreign Key respectively. Never use TABs in this as the layout gets mucked up. Use spaces and all is fine.
Table Name=[tblStudent]

[I]Field           Type      IndexInfo[/I]
StudentID       AutoNumber    PK
Family          String        FK
Name            String
University      String        FK
Mark            Numeric
LastAttendance  Date/Time