Exporting Table to Text file including Fielnames

  • Thread starter Thread starter AShi
  • Start date Start date
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
 
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
Export Spec Problem 1
Exporting and appending to txt file 4
Export to Tab delimited text file 4
Delimited Export Specification - independent of table 3
wrong sintax in tranfer text (vba) 1
Exporting .TAB file 1
Export Memo to txt - truncates at 255 1

Back
Top