Copy Recordset

[ctr1085]

I am able to copy a recordset to excel, but I can't figure out how to copy the column headers. Any information would be appreciated.

 

[RV]

Have a look at the TransferSpreadsheet and the TransferText Methods in Access Help.

RV

 

[ctr1085]

I checked this option out. The only problem I'm running into is the fact that I don't want to save the spreadsheet. I want to open an Excel occurance without saving and paste the recordset.

Is there a way to goto the header information in a recordset?