TransferText cmd appending unwanted quotes

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

When using the TransferText command to output table data into a comma
delimited text file unwanted double quotes are being appended around
each row.

Code I've written:
DoCmd.TransferText acExportDelim, , "combined", path

Current output:
"DS,,AAL4381,1022,6761,20020628,C,2419609"
"DS,,ACD9040,1022,6761,20020625,C,2419938"

Intended output:
DS,,AAL4381,1022,6761,20020628,C,2419609
DS,,ACD9040,1022,6761,20020625,C,2419938

Can anyone out there help me out?

Cheers,

Greg
 
Export the file manually first. Select the table/query to export, got
File >> Export, select 'Text Files' from the "Save As Type", Go throug
the wizard selecting how you want the file to export (without doubl
quotes). Once complete, try your code again, it should now expor
exactly as you set it.

HT
 
Back
Top