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?
lbsmAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TomMicrosoft ISV PartnerCommented:
Yes very possible, if you use some vb script. Let me know if this is your level
0
peter57rCommented:
How do you identify which records have now been updated?
0
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.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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.
0
GRayLCommented:
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.city = xl.city,
ac.region = xl.region,
ac.country = xl.country,
ac.zip = xl.zip;

The field names may not be 100%, but you get the idea.
0
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.

0
GRayLCommented:
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.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.