Macro using OutputTo text format (1 Viewer)

SherriKilgore

Registered User.
Local time
Today, 10:39
Joined
May 4, 2012
Messages
19
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

"Access- Imagineer that!"
Local time
Today, 10:39
Joined
Nov 1, 2006
Messages
550
You may need some VBA

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

Cheers!
Goh
 

Users who are viewing this thread

Top Bottom