How to update data in cells within Excel?

Lee · Aug 18, 2004

Hi guys,
I have a spreadsheet that I've created which provides an
analysis of data within an Access database. Is it
possible to update columns or individual cells within the
spreadsheet from within the Access database?
For example, cells B2:B23 correspond to the results of a
query called qryAnalysis1. Another cell (B27)
corresponds to a Count query called qryAnalysis2.
Is there a website with further help on this topic
perhaps?
Thanks for any help you can give.
Regards,
Lee

Gary Walter · Aug 18, 2004

Hi Lee,

I would think these KB articles would
get you going (plus they use late-binding
so you will start out on the right foot).

http://support.microsoft.com/?kbid=210288
ACC2000: Using Automation to Transfer Data to Microsoft Excel

http://support.microsoft.com/?kbid=247412
INFO: Methods for Transferring Data to Excel from Visual Basic

Good luck,

Gary Walter

Lee · Aug 18, 2004

Thanks for the quick response Gary.
They certainly look very helpful. I'll see what I can
fathom from them!!
Kind Regards,

Lee