ACC2000: Import Errors Table Not Created During Failed Import (207789)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q207789
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

Microsoft Access does not create an Import Errors table after an import of a text file or spreadsheet fails.

CAUSE

The circumstances under which Microsoft Access creates an Import Errors table have changed from earlier versions of Microsoft Access. Microsoft Access creates an Import Errors table only in the following situations:
  • The data in a Numeric field is too large or too small for the field size of the destination field. For example, the destination field has a FieldSize property set to Byte, but the data contains a value greater than 255.
  • The table to which you are appending the data contains replication fields.

MORE INFORMATION

The Import Errors table contains descriptions of the errors Microsoft Access encounters when trying to import a text file or spreadsheet. The table includes field names and row numbers that indicate which data has caused errors.

Steps to Reproduce Behavior

The following example attempts to import a record that violates referential integrity into the Order Details table in the sample database Northwind.mdb.

  1. In Microsoft Windows, start Notepad, and type the following items, separated by a comma:

    9,test,-1,5,0.00

  2. Save the text file as C:\My Documents\OrdDetails.txt.
  3. Start Microsoft Access, and open the sample database Northwind.mdb.
  4. On the File menu, click Get External Data, and then click Import.
  5. In the Import dialog box, select Text Files in the Files Of Type box.
  6. Locate the folder C:\My Documents, select OrdDetails.txt, and click Import.
  7. On the first screen of the Import Text Wizard, click the Delimited option, and then click Next.
  8. On the second screen of the Import Text Wizard, click Next.
  9. On the third screen of the Import Text Wizard, click the "In an Existing Table" option, and select the Order Details table from the list.
  10. Click Finish. Note that you receive the following error message:
    Microsoft 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 or the FieldSize property in the destination table.

    *If records were lost, either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables. Do you want to proceed anyway?
  11. Click Yes. Note that Microsoft Access does not create an Import Errors table.

REFERENCES

For more information about the Import Errors table, click Microsoft Access Help on the Help menu, type Import Errors table messages in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbprb kbusage KB207789
©2004 Microsoft Corporation. All rights reserved.