Problem importing excel data into existing table

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

Guest

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.
 
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
 
Back
Top