ACC2000: Import Errors Table Not Created During Failed Import

• Microsoft Access 2000

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

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.

Additional query words:

Keywords          : kbusage kbdta IsmTxtd IsmProb IsmTxtfx IsmExl4 IsmExl5 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 13, 1999