How can I include the header in .txt export

G

Guest

Hi,

Running the following to export my text file.

DoCmd.TransferText acExportDelim, mySpec, myStr, destdir & myFIleName &
".txt", False, ""

Would like to include the header in line 1.
Is there something I need to do in vba or is it in the export specification?
n.b. Using Access 2k3

Bruce
 
N

Nikos Yannacopoulos

Bruce,

Change False to True in the [HasFieldNames] argument!

HTH,
Nikos
 

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

transfer text query parameter 1
Transfer Text with more than 2 decimals. 3
ProgressBar 1
Logfile 2
"." changes to "#" in Access VBA DoCmd.TransferText call 2
Export to File with Current Date 2
How can I export a table into .txt file including the header? 1
Export Table to fixed length txt file 1

Top