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

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

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.