Export Access table to text file without field names or column headers in output file(.txt)? Is it possible?

[JohneX]

I tried this code and it works. But, the field names(headers) are included in the output .txt file.

DoCmd.TransferText acExportFixed, "FILE Export Specification", "SOURCE_TABLE", "C:\test\output.txt", True

 

[ranman256]

you set all those parameters in the "FILE Export Specification".
check mark all settings then the export/import will do it.

 

[pxmike]

I tried this code and it works. But, the field names(headers) are included in the output .txt file.

DoCmd.TransferText acExportFixed, "FILE Export Specification", "SOURCE_TABLE", "C:\test\output.txt", True

change the "TRUE" to "FALSE"

 

[jackd]

Documentation via Google search "MS Access docmd.transfertext"

DoCmd.TransferText method (Access)

Office VBA reference topic

docs.microsoft.com