Remove quotes from .csv file

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

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?
 
export the file tab delimited, this will remove the quotes
and add spaces around the data
 
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
 
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.
 
Back
Top