B
b_lwalker
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?
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?