export to text losing column headers

[dleake]

hi all,

I need to automate a process to export an Access table to a tab delim text file. I set up an export spec manually, including selecting the 'Include Field Names on First Row' check box. However when I run the export from code the text file that is created has all of the data but without the headers.

Have I missed something or is there a way to force Access to include the headers? I'm having to run the command from an Excel VBA module, code looks like:

Access.DoCmd.TransferText acExportDelim, "tab_delim_text", "tblImport_text", "C:\Documents and Settings\xyz\Local Settings\Temp\test.txt"

Thanks for any help

Dean

 

[dleake]

missing column headers - problem solved

i see there is a parameter after filename called 'HasFieldNames', the clue is in the name i guess...