Export to text file with no text qualifier

[Guest]

How do I export data to a text file using the transfertext command and having
the data be comma delimited with no quotes?

I can export comma delimited with and without quotes using the Export
wizard. How could I automate these two exports? Are there other methods?

 

[Ken Snell [MVP]]

Use the TransferText method (macro or VBA code) to do the export. You can
then use an export specification (which you create by manually doing the
export once and saving the settings to a specification name) to format the
output as you desire.

 

[coxrail2]

I have this same concern except that when I export manually, the only
question that appears is the encoding method. I am never presented with the
option of saving specifications. I have read about the "import/export
wizard", but don't know how to start it. Suggestions?

 

[Ken Snell \(MVP\)]

You create an Export (or Import) Specification by manually beginning the
export (or import) process. When you're in the wizard window, select the ;
character as the delimiter, and set any other settings you want (field
names, data types, etc.). Then, before you click the Finish button, click
the Advanced button at bottom left. In the new window, you'll see all the
settings you've specified. ClickSave As button and save them as an import
specification (name it whatever
you want, e.g., "MyExportSpec" or "MyImportSpec", for example). Click OK
button to return to the main window of the wizard. Then click Cancel button
to cancel the rest of the export (or import).

Now go to your TransferText macro/code and add the name of the export (or
import) specification to the appopriate argument position.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[coxrail2]

Can you possibly tell me how to kick off the "wizard?" The is no "wizard
window" of any sort. As I mentioned above, I am never presented with the
option of saving specifications.

 

[Ken Snell \(MVP\)]

File | Export