locked
not seeing "From Oracle Database" choice RRS feed

  • Question

  • I have Excel 2016. Under Get and Transform, when I go to New Query-> From Database, I only see SQL Server, Microsoft Access, and SQL Server Analysis Services Database. I'm looking for the Oracle Database choice. The Oracle 11g client is installed. What am I missing? Thank you.
    Wednesday, February 17, 2016 5:07 PM

Answers

  • Hi there. Oracle is only available in certain Office SKUs. See this post for more info:

    https://blogs.office.com/2015/09/18/new-ways-to-get-the-excel-business-analytics-features-you-need/

    If you have a version of Office that should include the Oracle connector but you still aren't seeing it, please let us know.

    Ehren



    Thursday, February 18, 2016 12:29 AM
  • Yes, connecting to Oracle using ODBC should work, even in Office Standard.

    Ehren

    • Marked as answer by GSW_Champs Saturday, February 20, 2016 12:49 AM
    Thursday, February 18, 2016 11:16 PM

All replies

  • Hi there. Oracle is only available in certain Office SKUs. See this post for more info:

    https://blogs.office.com/2015/09/18/new-ways-to-get-the-excel-business-analytics-features-you-need/

    If you have a version of Office that should include the Oracle connector but you still aren't seeing it, please let us know.

    Ehren



    Thursday, February 18, 2016 12:29 AM
  • Hi Ehren,

    I'm running Office Standard 2016. Looks like I'll need 365 ProPlus or one of the Professional versions, correct? Is there any way to connect to Oracle database using the "From ODBC" choice if I have the ODBC driver for Oracle installed? If so, can you point me to there? Thank you for your help!

    Thursday, February 18, 2016 2:04 AM
  • Yes, connecting to Oracle using ODBC should work, even in Office Standard.

    Ehren

    • Marked as answer by GSW_Champs Saturday, February 20, 2016 12:49 AM
    Thursday, February 18, 2016 11:16 PM