Handle Unique Contraint During Buld Inserts

[EWill]

I have several thousand records that I am inserting into an Access
table, which has a unique constraint on one of the fields. Currently
when a duplicate record is found the insert aborts and the error msg
is displayed (via my ErrorHandler).

How can I continue processing if when a duplicate value insert is
attempted.
When inserting 1000 records if 3 are dupliates I would like to go
ahead and insert the 997 non duplicate records. (Note I can not
remove the contraint from the table..)

And Code examples would be greatly appreciated .....


Regards,

 

[Tom Ogilvy]

Does On Error Resume Next work?

 

[Frank Kabel]

Hi
you may post this to the Access NG