Import excel into Access with duplicate records

[francesywhwang]

Hi all, I would like some help, in my import of excel file.
I noted access will inform number of records duplicated,
What I would like to know is there anyway for access to show me the duplicated record such as the ID in duplication.

Appreciate very much your help.

 

[Joe4]

Are you importing with a priamry key so that the duplicate records are being rejected and not imported?

If so, I would recommend importing either without a primary key, or use autonumber so that all records are imported. You can then use queries to identify/report/weed out duplicates.

 

[Gates Is Antichrist]

Extending jmiskey's correct answer: Permit the duplication, and use the "Find Duplicates Query Wizard." The only way I know to invoke it is under the lame "button" named "New" in the Queries pane. (I go straight to design mode with alt-d essentially always, so if you're like me you haven't even been by there since you first learned Access!)