thread705-1466496 - MS Access 2003

[meckz]

I have been getting the same error and did not see a resolution to this thread. It is simple code:
DoCmd.TransferText acExportDelim, "TabDelimited", "TempConv", Trim$(OutputFileName)

I have tried hard coding the file name into the command "C:\TEST\Converted.txt"

I still receive the error with the file name as "Converted#txt"

Was there final solution or does this just not work in Access?

I have been spending several hours and accomplished nothing.

Thanks

 

[TheFitz]

Hey Meckz,

I've had a quick look at this one for you, and I can't see any easy way to do it using the code you're using. If I were going to do this, I'd use FSO - File System Object.

http://www.aivosto.com/visdev/fso.html

File System Object allows you to open a file and manipulate it as you want. In your case, write each field then a tab then the next field etc.

I did a quick search for File System Object and VBa and got the above link, and also found a tutorial if it helps:

http://www.techbookreport.com/tutorials/fso1.html

Hope this gives you a little insight into it. . . .

Regards,


Fitz
Did you know, there are 10 types of people in this world:
* Those who understand binary
and
* Those who Don't!!