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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending records to a table from an Excel file 16
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Importing Data Error 2
Importing from Excel 4
Error entering data in a form 1
Unable to Append All the Data to the Table 3
Cannot Append Data to Access Table 1
Report Group Footer DLookUp 0

Top