Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
familiar with Oracle Objects for OLE?
Is anyone familiar with Oracle Object for OLE (OO4O)?
I have a script set up which will retrieve the desired data into the Dynaset, but I'm not really very familiar with it all, yet. At the moment, the only way I know of to put the data retrieved from the Oracle table into an Excel sheet is to run record by record, field by field, assigning it into the cells. Is there some quicker way that I can just 'plop' the whole set of retrieved data into a blank sheet? Thanks. Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
familiar with Oracle Objects for OLE?
Hi Mark
I haven't used oo4o for a very long time. But with ADO (and I believe DAO) recordsets can be pasted into worksheets with Sheets(1).Range("A2").CopyFromRecordset myRecordset give it a try. HTH. Brest wishes Harald "mark" skrev i melding ... Is anyone familiar with Oracle Object for OLE (OO4O)? I have a script set up which will retrieve the desired data into the Dynaset, but I'm not really very familiar with it all, yet. At the moment, the only way I know of to put the data retrieved from the Oracle table into an Excel sheet is to run record by record, field by field, assigning it into the cells. Is there some quicker way that I can just 'plop' the whole set of retrieved data into a blank sheet? Thanks. Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
familiar with Oracle Objects for OLE?
Hello again, Harald,
Thanks again for your suggestion. I will try it. Mark "Harald Staff" wrote: Hi Mark I haven't used oo4o for a very long time. But with ADO (and I believe DAO) recordsets can be pasted into worksheets with Sheets(1).Range("A2").CopyFromRecordset myRecordset give it a try. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is anyone familiar with the pull formula in excel? | Excel Worksheet Functions | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
experience with Oracle Objects for OLE | Excel Programming | |||
Dynamically Assign Objects to Form Objects. | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |