CSV Export Question

[jamez05]

I'm using access 2003. I'm trying to export the results
of a query using DoCmd.TransferText acExportDelim.

This works fine, but the csv file does not contain the column headers, which I need to have. I've tried setting the attribute hasfieldnames attribute to "Yes" to no avail.
Is there an easy way to handle this?

 

[jamez05]

Figured it out, was doing "Hasfieldnames = true" and changed to just "true" and it worked:

DoCmd.TransferText acExportDelim, , "qryDelimited", "C:\Documents and Settings\jniesen\Desktop\bsaf\test.csv", True