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

[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

 

[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

 

[Guest]

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.