Col Header in Transfertext - I don't want Quotes

[Ste4en]

Hello, Below is a converted Macro - basically I want to export to a txt file a col of data with a heading of the field name. The heading and field name is always the same 09F20F00F00ROSTER. If I run the code below or macro it works fine except for the quoteds on the heading eg "09F20F00F00ROSTER". Can u please help me modify this code so there are no quotes.

Thanks
Steve


Function macTricoderRstr()
On Error GoTo macTricoderRstr_Err

DoCmd.TransferText acExportFixed, "QryTricoderDownload Export Specification", "qryTricoderDownload", "j:\gate security system\RosterToTricoder.txt", True, ""


macTricoderRstr_Exit:
Exit Function

macTricoderRstr_Err:
MsgBox Error$
Resume macTricoderRstr_Exit

End Function

 

[fuzzygeek]

Redo export spec

Redo your export spec, when you come to the window that says has headers, to the right of it is a combo box that selects the delimiter for your header, choose "none"

 

[Ste4en]

Thanks - same result. Here is a few lines from the output file..

"09F20F00F00Roster"
333333333Eli Aburto
222222222Timothy L Anderson

Any other iseas?

 

[fuzzygeek]

Just checking

Just to make sure that we are talking about the same place see attached word document with image. If I can get it to attach.

 

[Ste4en]

Yes, that is what I did with no change.

 

[fuzzygeek]

Cannot duplicate problem

The following are the results of my export:

09F20F00F00Roster
333333333Eli Aburto
222222222Timothy L Anderson

I'm using OfficeXP. But I cannot duplicate your results. Anyone else???