Append Error Message

B

Beep Beep

While importing a number of Excel files into Access I have come across one
file that I get the following message:

The contents of fields in 0 records () were deleted and 3466 records were
lost due to key violations

Any ideas how to resolve this. The file is a text file and there doesn't
seem to be any problem with the others.
 
G

Golfinray

My guess is that you are trying to update a field with text that is set to
number, or trying to update a field where the datatype is text with numbers.
 
Top