Export FieldNames From Query

[RainX]

Hi all,

I'm trying to export a query into a text tab delimited file by using

DoCmd.TransferText acExportDelim, "ImportSpecx", stDocName, File_Path, Yes
I've also tried
DoCmd.TransferText acExportDelim, "ImportSpecx", stDocName, File_Path, True

But none of these export the Query Field Names. Is there any way i can get the Field Names in the exported file?

Thanks in advance

 

[petehilljnr]

My guess is that you have not checked "Include Field Names on First Row" in your "ImportSpecX" specification.

I'd check that first.

Regards,
Pete.