exporting csv

  • Thread starter Thread starter JIM H.
  • Start date Start date
J

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.
 
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.)
 
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.
 
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.
 
Back
Top