DoCmd.TransferText acExportDelim, , "Tbl_Temp2", "C:\Test1.txt"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use DoCmd.TransferText acExportDelim, , "Tbl_Temp2", "C:\Test1.txt" to
export my table each record begins and ends with a quotation mark. Can
anyone tell me how to get an output space delimited text with out the
quotation marks?

Thank,


Jim
 
GardenJim said:
When I use DoCmd.TransferText acExportDelim, , "Tbl_Temp2", "C:\Test1.txt" to
export my table each record begins and ends with a quotation mark. Can
anyone tell me how to get an output space delimited text with out the
quotation marks?

Thank,


Jim
Click to expand...
 
Opps! previous post got sent before I typed anything.

Do a transfer manually. Once you have the export wizard open, click on the
Advanced button. You can define your delimiters, etc. there. Then save the
options as a specification with a name. Then when you automate it, use the
SpecificationName argument to tell it how to format the output.
 
Back
Top