Import From Excel

[Pepper]

I have been receiving an Excel list file from another group, at least once a
week, with many duplicate records in it and I need to remove the duplicates.
One of the fields is Social Security Number, so that is a good candidate to
make a primary key field. When I then import the Excel file into the Access
table, the all the records are not imported, do to key violations. I just
need someone to verify for me that what is imported is one of each of the
duplicates, plus those that are not duplicates.
Thanks from an amatuer
Pepper

 

[John Spencer]

That is what should happen. You should get one record imported for each SSN
value.

If you want to check, you could run a Distinct query on the SSN in the Excel
file to see how many rows are returned before you import. Then see how many
rows are in the table after the import.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Pepper]

Thank you very much.

That is what should happen. You should get one record imported for each SSN
value.

If you want to check, you could run a Distinct query on the SSN in the Excel
file to see how many rows are returned before you import. Then see how many
rows are in the table after the import.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County