familiar with Oracle Objects for OLE?

[Guest]

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

 

[Harald Staff]

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

 

[Guest]

Hello again, Harald,

Thanks again for your suggestion. I will try it.

Mark