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? |
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? |
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. -- |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com