TransferText / Schema.ini Text Qualifier Problem

[AndyHorn]

Hi,

I'm using the TransferText method along with a Schema.ini file to export records from an Access Table into a .csv file.

However, it creates the file with double quotes, " , around each Text field to Qualify that data as text. This is a problem when importing the .csv file into Sage as it imports the double quotes as part of the text field.

If I use the built in Access Export utility, under the Advanced tab it allows me to set the Text Qualifiers as {none}, so all I get in the .csv file is the data seperated by commas.

How can I set the Text Qualifier to none either in VBA or in my Schema.ini file?

Example of what I Currently get: "AL3817","T0010"
Example of what I need: AL3817,T0010

VBA Code
--------
Private Sub Command238_Click()
stFileDate = Format(Date, "ddmmyyyy")
stPath = "C:\"
stFilename = stPath & "SageCustomers" & stFileDate & ".csv"
DoCmd.TransferText acExportDelim, Schema, "SageImportTable", stFilename, True
End Sub

Schema.ini
----------
[SageCustomers06042005.csv]
ColNameHeader=True
MaxScanRows=0
Format=Delimited(,)

Any advice welcome. Thanks