TrasnferText acImportDelim? (1 Viewer)

[Rick Stanich]

The code below imports my text file, but it ignores most spaces leaving me a useless table of concatenated data.
The text file is space delimited.

DoCmd.TransferText acImportDelim, , strTable, strInputFileName, False

How can I import a text file space delimited?
I have no problem importing a space delimited excel file, alas, the program that generates the text file uses its own proprietary crap for exporting.
If possible I wish to avoid passing the text files thru excel to convert.

 

[SOS]

Have you created an import specification yet?

 

[Rick Stanich]

I just stumbled onto that from another post.
http://www.btabdevelopment.com/main...teanImportSpecification/tabid/98/Default.aspx

After creating the spec, it works well.

 

[SOS]

I just stumbled onto that from another post.
http://www.btabdevelopment.com/main...teanImportSpecification/tabid/98/Default.aspx

After creating the spec, it works well.

glad to hear