From: Douglas J. Steele on 23 Nov 2009 15:58
Sorry, nothing comes to mind.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"gmazza via AccessMonster.com" <u37142(a)uwe> wrote in message
> strFile = "P:\Nav\SCMHeader0000001.txt"
> Douglas J. Steele wrote:
>>What's in strFile when the TransferText command is running?
>>>I don't have that extension, I have & ".txt"
>>[quoted text clipped - 31 lines]
> Message posted via AccessMonster.com
From: gmazza via AccessMonster.com on 23 Nov 2009 16:11
Its weird because when I take out the specs and just leave a comma like this:
DoCmd.TransferText acExportDelim, , "SCMHeader", strFile
then the Export works fine, but every field in the .txt file has quotes
around it. Only way to get rid of the quotes is to use specs no?
So when I remove the specs the Export doesn't complain about a file not
exisitng, but now I have no specs and need to get rid of the quotes. Any
thoughts on that?
Douglas J. Steele wrote:
>Sorry, nothing comes to mind.
>> strFile = "P:\Nav\SCMHeader0000001.txt"
>[quoted text clipped - 5 lines]
Message posted via AccessMonster.com