Importing customers

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.
Thanks
Tim

Tags:
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *