CopyFromRecordset for Oracle ?

[Rich]

I am using Excel 97.

I wanted to know if there is a command like CopyFromRecordset that
can be used with Oracle?

 

[keepITcool]

Excel97 has a copyfromrecordset method, BUT it supports only DAO not ADO.
DAO supports JetEngine thru ODBC, but no Oracle.
Read:
http://www.orafaq.com/faqmsvb.htm

Excel2000 and above DO support CopyFromRecordSet on ADO.

However you CAN create an ADO recordset and transfer to the sheet with a
simple loop.
read this:
http://www.erlandsendata.no/english/index.php?d=envbadacrs2ws

HTH


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Jamie Collins]

keepITcool wrote ...

DAO supports JetEngine thru ODBC, but no Oracle.
Read:
http://www.orafaq.com/faqmsvb.htm

The article says DAO has no advantage over ODBC but in my experience
it's worse than that i.e. Oracle reacts very badly to DAO resulting in
frequent crashes.

Jamie.

--