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

  • Thread starter Thread starter Mark
  • Start date Start date
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?
 
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
 
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?
 
Mark said:
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?
Click to expand...

No a primary field need not be consecutive numbers. A name may work if
it is unique. You can even build one by creating a field with say
firstname&lastname&city or some like combonation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you merge 2 databases into 1 database? 1
Merging 2 different access databases ?? 4
Can Access do this? 3
How do I combine 2 fields into 1 3
Multiple Records into Single Record 3
Import a general database into contact management database 3
Is there a Sales Database that prints invoices for Access? 18
cannot pull updated access database into mail merge 3

Back
Top