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?
If so, does anyone have some example code that shows how to read the Recordset and populate specific cells?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
manojamin,dhwanilshah...
Thanks for your help.
Thanks for your help.
http://support.microsoft.com/support/kb/articles/Q112/4/17.asp
and use this,
ExcelSheet.Cells(row, col).Value = youradors("yourfiled")