Curious Message When Importing

[Chaplain Doug]

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

Do you want to proceed?

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.

 

[Chaplain Doug]

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.

 

[JPC]

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.

 

[Chaplain Doug]

Indeed what you describe was the case. Thank you for replying. God bless.

 

[Gullum]

Where do I find "Allow Zero Length property"?

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.