export txt without header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i tring to export a txt file, but i want to avoid the header to be there..
is that possible

thanks in advance
 
You will have to use the TransferText method or action. Once of the
arguments is HasFieldNames. You can look up the details in VB Help
 
it works, but now i have a text file with " at the begin and the end of every
line
is it possible to avoid the ""??

thanks
 
Use the Export wizard to do the export once manually. When the wizard opens,
select the Advanced button. You can then customize how the output is
formatted. Once you have that set up, click on Save As. Give it a name.
Use this name in the File Spec argument of the TransferText.
 

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

Missing info when exporting report to txt file 2
Exporting and appending to txt file 4
Export: Every fourth line of data is extra/blank! 2
Export price field in txt file without $ currency symbol 9
Exporting to multiple files 4
Export specification not use? 1
Exporting Query in UTF-8 format with VBA 0
Exporting Access2003 database 1

Back
Top