Export to text file without double qoutes

[Don]

Hello,
I'm exporting some data(from Access 2003) to a text file to send out. I see
that the file have a double quote at the front and end of each line. I'm
thinking that the vendor I'm sending to won't want this.
How can I use the command below and not have the double quotes inserted?

DoCmd.TransferText acExportDelim, , "tmpCheckExport", Me.txtFileName, False

Thanks

Don

 

[Jeanette Cunningham]

Don,
the double quote is the text delimiter.
The export process puts a double quote at the start and end of each field
that is text data type, but not for a number data type.
To understand how to change this, do a manual export using the export
wizard.
In the export wizard, use the Advanced button to change the text delimiter
from a double quote to something else.
Save this export specification with an easy to remember name.
In the code that exports

DoCmd.TransferText acExportDelim, , "tmpCheckExport", Me.txtFileName,
False

use the saved specification from above. (vba help will show you how to use a
saved spec)


Jeanette Cunningham -- Melbourne Victoria Australia