exporting csv

[JIM H.]

Hello,
I need to export a table a comma delimited csv file. How
can I do that, when I use TransferText it export the text
filed with "" surrounded.
Thanks,
Jim.

 

[Ken Snell]

Create your own Export Specification, and then use that spec in your
TransferText command.

You create an Export Specification by beginning the export manually, and
then by clicking the Advanced button in lower left corner of the export
wizard window. Set your specs there, and save them under some name. Then
cancel the export.

In your TransferText command, the second argument is the name of the export
specification that you want ACCESS to use:

DoCmd.TransferText acExport, "ExportSpecName", (etc.)

 

[JIM H.]

Thanks for the reply. Where is this export wizart. the
only export I see File-> Export and it does not give me
advanced button.
Thanks,
JIm.

 

[Ken Snell]

Click the Export option. A file navigation window will open; select the file
to which you will do the export. Then click OK. Then the wizard window will
open.