Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyFromRecordset for Oracle ?
I am using Excel 97.
I wanted to know if there is a command like CopyFromRecordset that can be used with Oracle? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyFromRecordset for Oracle ?
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyFromRecordset for Oracle ?
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. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Sample for Oracle-to-Excel extraction with CopyFromRecordset | Excel Discussion (Misc queries) | |||
ADO & CopyFromRecordset performance | Excel Programming | |||
CopyFromRecordset Bug with Office XP | Excel Programming | |||
CopyFromRecordset does nothing | Excel Programming | |||
Copyfromrecordset Bug ? | Excel Programming |