Using TransferText

  • Thread starter Thread starter David
  • Start date Start date
D

David

I am using a macro to export a file. How can I make the
text qualifier {none} so that the values that I export
will not be contained withing quotation marks.

Thank you for your help.
 
First do an export by right clicking on the required table.
When the Export Wizard appears, follow the steps until the "Advance" button appear.
Once in there,select the Text qualifier as "None" and then save this "Export Specification" as e.g 'Proc01'
Now when you go to the macro that exports the file,Select "Proc1" under the "Export Specification" Tab.

Hope this helps.
 
Back
Top