Merging only 1 field into a database that does not contain that field

M

Mark

I have two simple databases that started off as Excel files. they both have
almost all the same information (contact information) but one of them does
not have the phone numbers, however it is the more accurate and up to date
database.

How can I pull the phone numbers off of the other database and match them to
the more accurate one, thus completing my final database for export/import?
 
J

John Conklin

You would have to have a field that could be used as a primary key field
between the two records.

Then add the phone number field to the table that does not have that field,
and then run an update query to update the phone number for each record that
matches on the primary key.

~John
 
M

Mark

Ok, but the database with the phone #'s is much, much larger than the one
with no phone numbers. So the primary keys would not match, correct?
 
Top