Problem importing excel data into existing table

[headly]

Existing table has pkey autonumber field, excel data doesn't. Want access to
generate those automatically after running an append query. I import the
excel data to a temp table, then create an append query. The query fails on
key violations and mentions data validation errors (but I have no data
validation rules). Some of the data is a yes/no data type, most is plain
text. Any ideas? TIA for your help.

 

[Jeff Boyce]

Data validation includes any required fields and zero-length strings in the
table definition. And if you have any unique indexes on the "permanent"
table, your appended data may be duplicating.

Regards

Jeff Boyce
Microsoft Office/Access MVP