Access Query to Txt file without colum names.

Question

I have an access querie which creates some output 3 coulmns lets say named "A", "B", and "C". I would like to, create a function where I can automatically output this query to a text file without the header rows. I am currently outputting the file to excel then opening the file and deleting the first row. the user then has to convert from excel to text.

Answer 1

You can use the TransferText method:

DoCmd.TransferText acExportDelim,,"myQuery", "D:\temp\myquery.txt"