Comersus Version: 709
Database type: Access
Frequency: Permanent issue
I'm trying to import customer data into the customers table in Access. I have an Excel sheet that has correct field headers, but I think it's preventing me from importing due to linked tables, but I'm not sure.
I get an error that says:
– records were lost due to key violations.
-either the records you pasted contain primary key values (which I think not), or they violate referential integrity rules for a relationship defined between tables.
I would appreciate any help. I have about 11,000 customers to import.