Skip to Main Content

How To Connect To Oracle 11g Database From Microsoft Excel

Vishwamber Shetty-OracleAug 24 2014 — edited Aug 25 2014

Hi All,

I have Windows7 64bit installed in my laptop.

I have Microsoft Excel 2007 installed.

I tried connecting to Oracle database ( This is not a local database).

Navigation used:

Data> From Other Sources > From Data Connection Wizard > Other/Advanced > Next > Microsoft OLE DB Provider For Oracle > OK

Now I get a pop up to enter:

  1. username
  2. password
  3. server

When I enter all the required details I get this error "ORA-06413 CONNECTION NOT OPEN"

Is there no need to give PORT number?


Vishwamber Shetty

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Sep 22 2014
Added on Aug 24 2014