Export Specification

[ions]

Dear VBA Expert.

I am running the following code....

DoCmd.TransferText acExportDelim, "ShawDrum Export Specification", "ShawDrum", "C:\Documents and Settings\Peter\Desktop\Shaw.txt"

The problem is that the SAVE Export specification doesn't save the fact that I want the first row to contain the field headers. I select this option in the Export Wizard... save the specification and run the above code. Despite this the exported text file doesn't include the field headings.

When I re-open the export specification the Include Row Headers option is not selected. How can I include the row Heading in the exported file using the Export specification.

Thanks so much!!!

 

[mdb4me]

You need to add another parameter to the TransferText to include the column headings. Adding ,TRUE after the export filename will add the header row.

DoCmd.TransferText acExportDelim, "ShawDrum Export Specification", "ShawDrum", "C:\Documents and Settings\Peter\Desktop\Shaw.txt",TRUE

 

[ions]

Thank you Sir.

Excellent worked.