How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask jnlichen Your Own Question

jnlichen, IT Manager
Category: Microsoft Office
Satisfied Customers: 165
Experience:  15+ years supporting users, computers, & software.
Type Your Microsoft Office Question Here...
jnlichen is online now
A new question is answered every 9 seconds

I exported a group of records into an excel spreadsheet to

This answer was rated:

I exported a group of records into an excel spreadsheet to use in a registration process for an event we had, at which information for several records was updated. Now I need to import the updated records into our database. What's the best way to accomplish this without creating duplicate records?

jnlichen :

Hello, my name is XXXXX XXXXX I can assist you.


jnlichen :

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.

jnlichen :

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.

jnlichen :

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.

jnlichen :

Here is a link to a sample.


jnlichen :

Give it a try and let me know if you have any other questions.



Will do. Thanks.

jnlichen and 3 other Microsoft Office Specialists are ready to help you
Customer: replied 4 years ago.

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?

Jeremy, give it a try. Without seeing your tables and data, I will have to trust your judgment as you know what you have.

Customer: replied 4 years ago.

Seemed to work. Thanks!

You are quite welcome. Please leave positive feedback on my answer above.

Customer: replied 3 years ago.

FYI, this thread can be closed.