Export Access table to csv file

[malaygal]

I exported an Access table to a csv file using:

cn.Execute "Select * INTO [TEXT;HDR=NO;DATABASE=C:\].tempform.TXT from tmptable1 "

Below is a sample output. How can I export it without the double-quote?

"0001","7500","FY11","Apr"," "," "," ","5.14810"
"0001","7500","FY11","Aug"," "," "," ","5.64386"
"0001","7500","FY11","Feb"," "," "," ","4.80772"
"0001","7500","FY11","Jan"," "," "," ","5.04811"
"0001","7500","FY11","Jul"," "," "," ","5.15309"
"0001","7500","FY11","Jun"," "," "," ","5.39846"

Any help will be greatly appreciated.

 

[HughLerwill]

A Google for '[TEXT;HDR=NO' turns up examples of similar queries including 'FMT=Delimited'. Does using that help you?

 

[PHV]

In access VBA I'd use the DoCmd.OutputTo method with a formatting query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886