By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,160 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,160 IT Pros & Developers. It's quick & easy.

Paste into Excel without MS Access Table header

P: n/a
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

Jan 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jan 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.