Merge Access Databases

I need help merging two databases. I have an access database that has address, city state zip, for my subscriber list. I recently had all the addresses updated and need to merge only the new addresses back to the original file (only 1000 have to be changed). The original file has a unique key and the appended file is in excel with the unique key as one of the columns. I want to keep the original unique key the same.  Is there a way to do this without cutting and pasting all of the new data?
Who is Participating?
GRayLConnect With a Mentor Commented:
You talk about merging two databases - don't you really mean two tables in the same database?  How do you get the Excel spreadsheet data into Access?  If you Link to it as I suggested then you need only to create the update query I suggested above  You need to identify the name of the excel table, the name of the larger Access address table and the field names that you want involved in the transfer.  
TomMicrosoft ISV PartnerCommented:
Yes very possible, if you use some vb script. Let me know if this is your level
How do you identify which records have now been updated?
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

lbsmAuthor Commented:
i just use the program, I am not a software engineer. if you give me step by step instructions I could figure it out.
lbsmAuthor Commented:
with regards to which records have been updated, the excel file has a code in a new column that identifies what has been changed on the record.
The Excel file with the 1000 or so records are all changes - right?  The unique key in the Excel table with the new address is identical to the unique key in the Access table with the old address - right?  Why not just link to the Excel file, so Access 'sees' it as a table and do an UPDATE query using an INNER JOIN:

UPDATE AccessTable AS ac INNER JOIN ExcelTable AS xl  ON ac.Key = xl.key SET
ac.add1 = xl.add1,
ac.add2 = xl.add2, =,
ac.region = xl.region, =, =;

The field names may not be 100%, but you get the idea.
lbsmAuthor Commented:
can you write out the steps to implement your solution. I think you want me to create a new query in design field, but I am lost after that. thanks.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.