Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel retrieves data from Oracle
make sure that you actually do have that DLL installed &
registered. Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi all, I would like to write a Excel macro program to connect to Oracle DB and retrieve data from it. I found from some websites that I should contain a sentance shown below in the source code: Set OraSession = CreateObject ("OracleInProcServer.XOraSession") However when I execute the program, it shows error 429 and said ActiveX can't create object. Do I need to do anything so that I can continue my programming? . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel retrieves data from Oracle
Hi, thanks for your reply first!
I am not very familiar with Macro and connection between Excel and Oracle. Would you please tell me how I can get the DLLs and register them, or provide any websites for my own learning? Thanks again Patrick Molloy wrote: make sure that you actually do have that DLL installed & registered. Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi all, I would like to write a Excel macro program to connect to Oracle DB and retrieve data from it. I found from some websites that I should contain a sentance shown below in the source code: Set OraSession = CreateObject ("OracleInProcServer.XOraSession") However when I execute the program, it shows error 429 and said ActiveX can't create object. Do I need to do anything so that I can continue my programming? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form that retrieves existing data from table and allows editing | Excel Discussion (Misc queries) | |||
Import Data from Oracle to Excel | Excel Discussion (Misc queries) | |||
Loading data from Excel to Oracle | New Users to Excel | |||
Exporting Excel data to Oracle DB | Excel Discussion (Misc queries) | |||
Formula retrieves wrong data | Excel Discussion (Misc queries) |