2 Replies Latest reply: Aug 24, 2014 11:13 PM by Sdhamoth-Oracle RSS

    How To Connect To Oracle 11g Database From Microsoft Excel

    Vishwamber Shetty-Oracle

      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