If you don’t have the Oracle Provider for OLE DB option, download the Oracle Data Access Components for Windows from Oracle site. Click the Oracle Provider for OLE DB choice. The Other/Advanced selection launches the Data Link Properties dialog with the Provider tab open and active. Click on the From Data Connection Wizard item.ģ.The Data Connection Wizard provides a number of Microsoft data sources, but you click the Other/Advanced option to connect to an Oracle database.Ĥ. When you click on the From Other Sources icon, you’ll get the following drop down list. Click on the Data ribbon, and then click on the From Other Sources icon in the Get External Data section, as shown:Ģ.
Here are the instructions with screen shots:ġ. The Oracle client software allows you to resolve an Oracle Network Alias (found in the %ORACLE_HOME%\network\admin\tnsnames.ora file). The key to making this work is having the Oracle 10g Client software or an Oracle 11g database on the same machine. Actually, it should work on any current version of the Oracle database.
#Excel power query tutorial oracle how to
This shows you how to query an Oracle 11g database from Excel 2007 ( only available when you do a FULL install of Excel 2007). Ultimately, Microsoft Excel is the de facto tool of many accounts and financial analysts, protests notwithstanding.
I caught a post on the OTN forum asking how to do this, and it happened to be something I’m working on for a new course that I’ll be teaching on data analytics.