Exporting Table to Text file including Fielnames

A

AShi

I am using following to transfer Access table to text. I have created Export
specs using Advance tab in export with Tab Delimited file. When i expport it
does not export field Names.
DoCmd.TransferText acExportFixed, strExportSpec, strTable,
"\\Enterprise\mlhsapps\ExportTest.txt", False
 
A

AShi

Thanks that works but field names are saperated by commas insted tab, is
there work aroun that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Table to Text file including Field names 13
Exporting and appending to txt file 4
Exporting .TAB file 1
Export Memo to txt - truncates at 255 1
Export to Tab delimited text file 4
Why does TransferText trim when importing string 7
docmd.transfertext acExportFixed 0
TransferText command 3

Top