Hello Everyone,
I have Access 2003.
I want to know if there is a way to make Access generate a "duplicate erros
table".

What I mean is this;
On some imports- Excel into an existing Access table- if something goes
wrong with the import, Access will give you a dialog box at the end of the
import wizard that something like, "some records could not be imported due to
blah blah blah... the records that could not be imported have been put into a
table called paste errors (or something)". You open up the "paste error
tables and it shows you what records did not successfully import.

I'm trying to import part numbers from an excel sheet into an existing
access table. the access table has on key field, which happens  to be the
PARTNUMBER field. I know that some of the records I'm importing will
duplicate part numbers already in the access table. I know that the access
table will not accept duplicates of the key field, and I want access to give
me a "duplicate errors table" that shows me what records did not import.

Right now when I try to import the escel sheet, acces will only give me a
dialog box, telling me that some records could not be duplicated due to key
violations, then it proceeds to import only those records that are not
duplicates, without letting me see the fialed records.

Hence the need for a "duplicates error table" of some sort. Or even some way
to generate a report would be helpful.
Thanks,