Curious Message When Importing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003. I am importing a comma-delimited text file into an existing
Access table. When the import is complete I get the information dialog
saying:
Microsoft Acces was unable to append all the data to the table.

The contents of filed in 0 record(s) were deleted, and 0 records were lost due to key violations.

*If the data was deleted, the data you imported or pasted doesn't match the field data types or the file size properties of the destination table.
*If the records were lost . . .
Click to expand...
Do you want to proceed?
Click to expand...

I click "Yes" and the process completes. All the data is imported. Why am
I getting this seemly meaningless information dialog (0 records deleted, 0
records lost)? How can I get rid of it? Thanks and God bless for any help
you may give.
 
Although the information dialog says that 0 rows were deleted and 0 rows
lost, The problem was being caused by one (1) record. This one record was not
imported. However, there was no error table created to let me see that this
one record was not imported.
 
I've experienced this same problem when importing from excel. In my case,
the cause was that one field entry was blank/null, and the table design Allow
Zero Length property was No for this field. Somewhere in your data this is
probably the case.
 
Where do I find "Allow Zero Length property"?

Chaplain Doug said:
Access 2003. I am importing a comma-delimited text file into an existing
Access table. When the import is complete I get the information dialog
saying:



I click "Yes" and the process completes. All the data is imported. Why am
I getting this seemly meaningless information dialog (0 records deleted, 0
records lost)? How can I get rid of it? Thanks and God bless for any help
you may give.
Click to expand...
 
Back
Top