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.