Avoiding duplicates when importing values

[lass9509]

Hello,



I have this problem that when i import a list of values from excel into a data table, and when I at a later point want to update some values (another import, but with updates values), i get duplicates. I have tried to set a field as primary key, but that does not allow me to import values where the primary key appears.

Can someone help me find a solution to my problem.

[JoeM]

One way to do this is to first import the data into an empty "temp" table, whose structure is exactly the same as your data table.
Then, create tqo action queries that do the following:
1. Perform and unmatched query between the temp table and data table, and make that an Append Query to add the new records to the data table.
2. Create a matched query between the temp table and data table, and make this an Update Query, updating the fields on the existing records that you need to do.

You will also want a Delete Query to delete out the temp table either at the very beginning or the very end, so that it is empty before the next import.
Once you set up the temp data and these 3 action queries, you may be able to create a Macro to do all the necessary steps with just one click.

[June7]

Can you set a link to the Excel?

Review Gustav answer in https://stackoverflow.com/questions/...g-in-ms-access