Delimited file import failing

[DBAMJA]

I can't seem to figure out what is happening with my import. I have a file that uses the | as the delimiter. When I manually import the file it works just fine but as soon as I set up an import specification and use it, it blows up and doesn't recoginze the | as a delimiter.

Anyone else have this issue and know how to get around it?

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[DBAMJA]

Sorry.... Here is the line in my code that I am using to import the file.


DoCmd.TransferText acImportFixed, "ResultsImport", "tblResults", "S:\Accounts Receivable\Shift4\CreditCardProcessing\" & sRemoteFile & ".txt"

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[traingamer]

Shouldn't you be using acImportDelim if you have a | delimiter rather than acImportFixed?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[DBAMJA]

Thank you...I am an idiot!!!

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.