TransferText cmd appending unwanted quotes

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
 

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

Top