View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default 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?

.