Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CSV Export Question

Status
Not open for further replies.

jamez05

Programmer
Jul 29, 2005
130
US
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?
 
Figured it out, was doing "Hasfieldnames = true" and changed to just "true" and it worked:
Code:
DoCmd.TransferText acExportDelim, , "qryDelimited", "C:\Documents and Settings\jniesen\Desktop\bsaf\test.csv", True
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top