MS Excel 2010 Database wizard - Oracle ODBC

Sort:
You are not authorized to post a reply.
Author
Messages
Michael Ewing
New Member
Posts: 5
New Member

    We are experimenting with using the MS Excel 2010 Database wizard with Oracle ODBC to query custom views of data in our S3 database tables.    We are able to see the non-materialized views, but the materialized views are not visible for selection.    We are using Oracle 11gR2 for our database.

    Any suggestions on what to do to make the materialized views visible for selection would be greatly appreciated.

    Thank you.

    ACCESS GNOME
    Basic Member
    Posts: 8
    Basic Member

      Have you considered using Microsoft Acces to query off your Oracle tables? I actually use both Microsoft Access and Oracle SQL Developer to connect to our S3 database and create queries. Oracle SQL Developer is a free download form Oracle's website. If you do not have admin rights to your database while using Oracle SQL Developer, you won't be able to save user defined functions, but it will allow you to save any queries you create. Hope this helps.

      *When viewing the Oracle SQL Developer directory tree for your database, you will see a folder named "Materialized Views".

      You are not authorized to post a reply.