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/...=envbadacrs2ws
HTH
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
(Rich) wrote:
I am using Excel 97.
I wanted to know if there is a command like CopyFromRecordset that
can be used with Oracle?