exporting with field names

[JIM H.]

Hello,
I export a table to a csv file with "DoCmd.TransferText
acExportDelim" and I would like to have field names in the
output file too. How can I do that?
Thanks,
Jim.

 

[Roger Carlson]

The 5th parameter in the command line specifies whether the it should export
fieldnames:

DoCmd.TransferText acExportDelim,,"yourtablename", "c:\the\file\name.csv",
True

--Roger Carlson
www.rogersaccesslibrary.com