Remove quotes from .csv file

[Vanessa]

I am exporting a query from MS Access 97 to a .csv file.

DoCmd.TransferText acExportDelim, , "AllData",
strPathFileTemp, False

The problem is the .csv file it creates contains quotes (")
around the data results.
"C",,,,,,,,,,
"C","SENDER","RECIPIENT","REPORT ID","SEQ NO"

How do you produce a .csv file without the quotes?

 

[none]

export the file tab delimited, this will remove the quotes
and add spaces around the data

 

[TC]

If you succeed in that aim, what then happens when a data value contains one
or more commas?

Value 1, Value, er, 2, Value 3, ...

TC

 

[John Nurick]

Hi Vanessa,

Export the file once manually. As you do so, click the Advanced button
in the wizard and create an export specification with the necessary
settings. Then pass this specification to TransferText.