step through append query errors

[Guest]

I'm trying to import a large table of company addresses from another database
using an append query. The data is dirty so understandably, so out of 1400
records, I'm getting 200+ key & validation rule violations when trying to do
it.

I would like to set up something that would allow me to pinpoint the records
that are in violation and optionally fix them as the import is being done.

Any ideas on how to do this?

 

[JohnFol]

You would have to do this using VBA code.