Link to home
Start Free TrialLog in
Avatar of GeekMan
GeekMan

asked on

Populating Excel cells with VBA/ADO

Is it possible to use an ADO Recordset to populate an Excel spreadsheet with data from an external database source (ie. Oracle)?
If so, does anyone have some example code that shows how to read the Recordset and populate specific cells?
Avatar of manojamin
manojamin

read this,

http://support.microsoft.com/support/kb/articles/Q112/4/17.asp 

and use this,

ExcelSheet.Cells(row, col).Value = youradors("yourfiled")


ASKER CERTIFIED SOLUTION
Avatar of dhwanilshah
dhwanilshah

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GeekMan

ASKER

manojamin,dhwanilshah...
Thanks for your help.