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

  • Thread starter Thread starter Brad
  • Start date Start date
B

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.
 
Brad said:
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.
Click to expand...


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.
 
Dirk,

Thank You!
Thank You!
Thank You!

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

Thanks again,
Brad
 
Back
Top