Remove quotes from .csv file

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?
 
N

none

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

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL PassThrough query - CSV Error 5
Create a csv file 11
Transfertext enclose number fields in quotes 6
Import csv file to Access 2003 table 2
Export Access Query to a pipe delimited .csv file 5
Date/Time Values when Exporting CSV File 2
Exporting mutliple queries into csv files 1
TransferText using wrong format 0

Top