none
Access Oracle from Excel VBA without any downloads or Oracle installs RRS feed

  • Question

  • I am working with Excel 2013 and Oracle 12. It is important in our case that users of VBA not have to do any installs and be able to use Excel out of the box.

    Is there a way to accomplish this? Can the Microsoft ODBC oracle out of the box do this, preferably if possible, using its higher level interfaces like OLE, ActiveX, etc. I have not seen many examples of accomplish this.

    I'd appreciate your thoughts and reference to examples of how to do it.

    Thanks

    Tuesday, January 17, 2017 5:05 AM

All replies

  • Hi,

    To answer your question straight, It is not possible to connect to Oracle DB via VBA without having Oracle driver installed in your computer locally. This is something which enables excel to connect to oracle DB using connection string.

    Now may I know, what is your requirement and why do you want to do this?


    Vish Mishra

    Wednesday, January 25, 2017 11:47 AM
  • The answer is no. You must either have the Oracle client software installed or the Oracle Instant Client.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Wednesday, January 25, 2017 6:16 PM