Duplicates Error Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Damon Johnson said:
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,
Click to expand...


Try:

1. Copy the destination table structure to a new table (TEMP).
2. Disable the primary key on the TEMP table.
3. Import the records to the TEMP table.
4. Copy the TEMP table on to the end of the Destination table.

This should give you a Paste Errors table during the copy.



--
 
Ahh yes, this is the same routine to delete duplicate records from a table,
which does give you the error table.
Thanks Michael.
 
Back
Top