Excel Automation Basics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prototype - 20 Jun 2007 14:31 GMT

This should be an easy one but I searched the board and was unable to find
anything that directly addressed my question. What is the best way to export
a recordset to excel? I simply want to export everything in the recordset
including the headers to excel. I need to do this in VBA.

Thanks,

Reply to this Message

Douglas J. Steele - 20 Jun 2007 14:44 GMT

See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> This should be an easy one but I searched the board and was unable to find
> anything that directly addressed my question. What is the best way to
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

prototype - 20 Jun 2007 15:54 GMT

Douglas,

That was exactly what I was looking for and very well written. Thanks!

> See whether my July, 2005 "Access Answers" column in Pinnacle Publication's
> "Smart Access" helps.
[quoted text clipped - 9 lines]
> >
> > Thanks,

Reply to this Message

Pat Hartman (MVP) - 20 Jun 2007 15:27 GMT

The TransferSpreadsheet Method/Action will do this. You just supply the
table/query name and the name of the file you want to create along with some
other optional arguments.

> This should be an easy one but I searched the board and was unable to find
> anything that directly addressed my question. What is the best way to
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message