I'm using the Docmd.TransferText method to import data from a text
file into a table. It works just fine, but it creates a table every
time called "Name AutoCorrect Save Failures", and that table contains
four fields, essentially telling me that it could not save the object
Table that received the imported text file (tblTsHolding). The line
of code is:
DoCmd.TransferText acImportDelim, "spcTsImport", "tblTsHolding",
strFileName
where:
spcTsImport is the import specification
tblTsHolding is an existing table
strFileName is a string variable that contains the text file name and
path as a string
What I don't understand is that it still imports the data no problem.
How do I prevent this annoying table from appearing every time I run
this command?
Ken Snell (MVP) - 18 Mar 2007 03:01 GMT
Turn off the Name AutoCorrect feature in the database (Tools | Options |
General).

Signature
Ken Snell
<MS ACCESS MVP>
> I'm using the Docmd.TransferText method to import data from a text
> file into a table. It works just fine, but it creates a table every
[quoted text clipped - 15 lines]
> How do I prevent this annoying table from appearing every time I run
> this command?
b_lwalker@hotmail.com - 18 Mar 2007 22:27 GMT
Yes - that makes sense. Cheers.