Using TransferText

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.
 
T

Theo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top