best approach to import data

[jomara via AccessMonster.com]

i have a database that wasnt designed by me that has 3 tables (Contacts,
Calls, TradeLogs) all linked with a field called ContactID that is the
primary field of the table Contacts. I have eliminated some of the fields in
contacts that were of no use and empty and renamed a few to better fit the
database. At one point we elimintated about 5000 records from the contact
database but left the corresponding entries in calls and tradelogs (really
bad move on my part) now i need to import everything into the new database
but i only want records from calls and tradelog that match the records in
contacts

 

[Robert Holman]

i have a database that wasnt designed by me that has 3 tables (Contacts,
Calls, TradeLogs) all linked with a field called ContactID that is the
primary field of the table Contacts. I have eliminated some of the fields
in
contacts that were of no use and empty and renamed a few to better fit the
database. At one point we elimintated about 5000 records from the contact
database but left the corresponding entries in calls and tradelogs (really
bad move on my part) now i need to import everything into the new database
but i only want records from calls and tradelog that match the records in
contacts