How can I include the header in .txt export

B

Bruce

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
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Transfer Text with more than 2 decimals. 3
3625 error 1
"." changes to "#" in Access VBA DoCmd.TransferText call 2
Export Specification File 0
Logfile 2
ProgressBar 1

Top