Exporting text to CSV

vmon

Registered User.
Local time
Today, 11:45
Joined
Jan 21, 2003
Messages
49
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"), _
Trim(rstExport.Fields("PoNumber")), _
Trim(rstExport.Fields("Vendor"))


I want file to look like:

H,12345,ACTION

I am getting:

"H","12345","ACTION"

Thanks for your help,
vmon
 
Excellent!
 

Users who are viewing this thread

Back
Top Bottom