I tried to post the error message but am not having any results.
So below is the text.
Microsoft Access was unable to append all the data to the table.
The contents of fields in 0 record(s) were deleted, and 92 records were lost due to key violations.
If data was deleted, the data you pasted or...
Many thanks for that.
Is there any function that informs you which record is the problem child?
The record I tracked down doesn't seem to have any duplicates within the list.
I've got a spreadsheet with the same field headers in Access and Excel.
I go through the import process under the External Data tab.
I get an error when I try to complete - seems to be a well-recognised error.
When I compare the imported records in Access to the records in Excel, there is one...