Copying Data without the header row

[darylharris]

Hello All,
Does anybody know a away of copying access data into other applications without the header row. An example being if you copy access data into excel it includes the header row in the spreadsheet. I often have to copy access data into industrial application software but usually paste into excel first (to get rid of the header rows) then from excel into the application. I would like to eliminate this step if I could but not sure how to copy without the header row.

Regards

Daryl

 

[jdraw]

Hello All,
Does anybody know a away of copying access data into other applications without the header row. An example being if you copy access data into excel it includes the header row in the spreadsheet. I often have to copy access data into industrial application software but usually paste into excel first (to get rid of the header rows) then from excel into the application. I would like to eliminate this step if I could but not sure how to copy without the header row.

Regards

Daryl

If you export the data from an Access table to a csv or txt file using the Export Wizard, you will get a form with an option to include/exclude Column Names.
If you do a docmd.TransferText there is an option there as well -- I think HasFieldNames which you can set to False.