CONNECTING TO ORACLE WITH MS OFFICE EXCEL

In EXCEL if you wanted to connect to the RPROODS DB as an external data source you can use the Oracle OLE odbc connection by going to data>get external data>from other sources> Then choose from data connection wizard Select other / advanced Then choose the Oracle Provider for OLE DB Next put in the details of the connection (reportuser/report) for username/password Now you access to the data.