Unable to append all the data to the table
Hi. I need help on MS Office Access TransferSpreadsheet Macro. I need to insert common data’s in the main menu or switchboard of a database. This is to get rid of inserting data’s one by one. I tried this step but I am getting an error as posted below:
Microsoft Office Access
Microsoft Office Access was unable to append all the data to the table.
The contents of fields in 0 record(s) were deleted, and 1 record(s) were lost due to key violations.
* If data was deleted, the data you pasted or imported doesn’t match the field data types.
* If records were lost, either the records you pasted contain primary key values that already exist integrity rules For a relationship defined between tables.
Do you want to proceed anyway?
Yes no Help