How to use VBA to export a Table without Headers and Borders

[Brad]

I need to feed data from Access into an accounting system.
Here is the DoCmd.OutputTo command that I am testing with.

DoCmd.OutputTo _
acOutputTable, _
"tblCustomers", _
acFormatTXT, _
OutputFileName, _
False, _
"", _
0, _
acExportQualityPrint

I need to just feed the data with VBA with no headers and borders.
I cannot find an explanation on how to do this.

Thanks in advance for your help.

 

[Dirk Goldgar]

I need to feed data from Access into an accounting system.
Here is the DoCmd.OutputTo command that I am testing with.

DoCmd.OutputTo _
acOutputTable, _
"tblCustomers", _
acFormatTXT, _
OutputFileName, _
False, _
"", _
0, _
acExportQualityPrint

I need to just feed the data with VBA with no headers and borders.
I cannot find an explanation on how to do this.

Thanks in advance for your help.

For this I think you want to use DoCmd.TransferText instead. That lets you
write out the data as delimited text or in fixed-width format (defined by an
import/export specification you can create), as you choose.

 

[Brad]

Dirk,

Thank You!
Thank You!
Thank You!

The DoCmd.TransferText works great.
I really appreciate your help.

Thanks again,
Brad