Macro using OutputTo text format

[SherriKilgore]

I created a macro to output a table as "txt" format, the results differ from using the "right'click export" method in that the macro txt is not delimited and the "export" method is . . . is there something special that needs to be done to get the same result as the "export" method?

 

[GohDiamond]

You may need some VBA

docmd.TransferText acExportDelim,SpecificationName,Source,ExportFileName,TRUE (if it HasFieldNames)

Cheers!
Goh