Paste into Excel without MS Access Table header

[dmkeith2]

This is probably easy to do but I can't find it in the groups.

How do I paste into an excel document without the MS Access headers? I
just want to paste the data.

Thanks

[Kc-Mass]

I don't believe you can do it with a mouse and keyboard.
In the interactive mode you get the header row and delete it.

You can do it without the header in VBA as follows:
'set the worksheet you want to paste into
Set xlSheet = xlBook.Worksheets("TheSheetToPasteInto")
'clear out the old data
xlSheet.Range("b2:v15000").Clear
'open the recordset you want to copy from
Set RS = db.OpenRecordset("QueryorTableYouGetDataFrom")
copy the data, without header, to the worksheet starting in cell "B2"
xlSheet.Cells(2, 2).CopyFromRecordset RS

Kevin C


<dm******@hotmail.comwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...

This is probably easy to do but I can't find it in the groups.

How do I paste into an excel document without the MS Access headers? I
just want to paste the data.

Thanks