Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello, my name is XXXXX XXXXX I can assist you.
What type of database are you using?
How are you connected to this database?
It's local, on my computer.
It's a Microsoft Access 2010 database.
Hello, the easiest way to accomplish this is to add the data to your database by using the "Get External Data" tool.
OK, but I don't want to create new records. I want to use the external data to update EXISTING records.
Import the excel file into Access into a temp table. Run an update query to take the information from the temp table and update the permanent table.
How do I run an update query? I've never created such a query.
Here is a link to a sample.
Give it a try and let me know if you have any other questions.
Will do. Thanks.
I made the mistake of not exporting the primary key when I created the external list. So, now that I'm using the external data to update records in my database, I have to use less perfect fields to match records in both tables. My solution, if it is one, is to join the tables using the LastName field AND the FirstName field - because a couple of records share last names with each other.
Before I run this update query, does that sound right to you?
Seemed to work. Thanks!
FYI, this thread can be closed.