The Import Errors table contains descriptions of most error messages Microsoft Access encounters when trying to import your text file or spreadsheet in a Microsoft Access database. The table includes field names and row numbers that indicate which data has caused errors.
Note In a Microsoft Access project, no Import Errors table is created. Consider using Data Transformation Services (DTS), which can be a faster and more flexible way to import and transform data. For more information, see the Microsoft SQL Server documentation.
If Microsoft Access reports errors, open the Import Errors table and try to determine why Microsoft Access can't import all of the records. The following table lists possible import errors and describes their causes.
| Error | Description |
|---|---|
| Field Truncation | A value in the file is too large for the FieldSize property setting for this field. |
| Type Conversion Failure | A value in the text file or spreadsheet is the wrong data type for this field. |
| Key Violation | This record's primary key value is a duplicate — it already exists in the table. |
| Validation Rule Failure | A value breaks the rule set by using the ValidationRule property for this field or for the table. |
| Null in Required Field | A Null value isn't allowed in this field because the Required property for the field is set to Yes. |
| Null value in AutoNumber field | The data that you're importing contains a Null value that you attempt to append to an AutoNumber field. |
| Unparsable Record | A text value contains the text delimiter character (usually double quotation marks). Whenever a value contains the delimiter character, the character must be repeated twice in the text file; for example:
"10 - 3 1/2"" disks/box" |
If you suspect that the problem is with your data, edit your text file or spreadsheet. If you're appending records to an existing table, you might need to change the table itself (reorder the fields or change data types, for example). When you have solved the problem, import the data again.