bogus error msg when using transfertext to import .txt file to table?

B

bf1

Hi,
Access 2k. I am using the transfertext method to load a .txt file into
a table. A msgbox appears upon execution of that line of code:

Microsoft was unable to append all the data to the table
The contents of field(s) in 0 records were deleted, and 0 records were
lost due to key violations.
.... Do you want to proceed anyway?

I click yes (of course- there are 0 errors according to the msg), the
line executes, and the data is loaded.

Is this just a bogus error message, or is there something else wrong
that the msgbox is NOT telling me? I verified that all of the records
were loaded, and it appears that none of the field contents were
deleted (just as the msgbox indicates). If everything was successful
with the transfertext, then why the msgbox?

TIA,
Beth
 
T

Tony D'Ambra

Is there a PasteErrors table created after the import?

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
 
B

bf1

Oops, forgot to mention that detail. There is not a PasteErrors table
after the import. This one has me flummoxed!

Thanks,
Beth
 
B

bf1

No, there is no PasteErrors table present after the import. Everything
seems to point to a successful import except the presence of the
msgbox.

Thanks,
Beth
 
B

bf1

If this reply shows up more than once, I apologize. The other replies
I sent have not been posted as of now.

No, there is no PasteErrors table created after the import. All signs
point to a successful import, except the very presence of the msgbox.
Thanks,
Beth
 
Top