Export to text file without double qoutes

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
Click to expand...

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


Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top