ACC2000: Import Errors Table Not Created During Failed Import

• 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.

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.