Import Validation rule violations

[purpleski]

Hi

I have imported an excel table into access as table IYS News (2800 records) and wish to append this to another table Attendees.

When I run the append query I have created I get the message "....and it didn't add ..... and 77 record(s) due to validation rule violations.

Is there a way to produce a query or report which shows which records are giving the problem?

Thanks.

 

[geeteshk]

check if the feild types match.

u can use on error

to go to a sub where u can add the current record
to a new table

 

[purpleski]

Thanks for that but I have checked that and the types match because I am able to import 2,723 records but have no idea which 77 have not been imported.

And I don't understand ho to do this

u can use on error

to go to a sub where u can add the current record
to a new table

Is there away of finding out. A query that will find the records in one table and not in another? All the records being imported have a unique email address.

Thanks.

 

[purpleski]

Solved it now using unmatched query wizard to creat a new table which I then appended.

Thanks.