Exporting text without double quotes 1

[vmon]

I am creating a text file (csv) and writing text to the file. Is there a way to export text without having my data enclosed in double quotes? Here is what I am trying.

Open "c:\john.txt" For Output As #1

Write #1, Trim(rstExport.Fields("RecTyp&quot, _
Trim(rstExport.Fields("PoNumber&quot), _
Trim(rstExport.Fields("Vendor&quot)


I want file to look like:

H,12345,ACTION

I am getting:

"H","12345","ACTION"

Thanks for your help,
vmon

 

[MasterPO]

Use 'Print' instead of 'Write'

When you substitute 'Print' you will lose the quotes, but the file will be formatted with TABS between the datafields:

Results:
H 12345 ACTION

Write the Print statement like this to get rid of the tabs:

Print #1, Trim(rstExport.Fields("RecTyp&quot) & ", " & _
Trim(rstExport.Fields("PoNumber&quot) & ", " & _
Trim(rstExport.Fields("Vendor&quot)

Results:
H, 12345, ACTION