How to Connect Excel to an Oracle Database

This wikiHow teaches you how to connect an Excel workbook to an Oracle database using Power Query.

Steps

  1. Image titled Connect Excel to an Oracle Database Step 1
    1
    Open your workbook in Microsoft Excel. Excel comes with a feature called Power Query (also called Get & Transform) that makes it easy to connect to an Oracle database.[1]
    • If you haven’t installed the Oracle client software on your computer, you’ll need to do so first. You can get the latest 64-bit version here, and the 32-bit version here.
  2. Image titled Connect Excel to an Oracle Database Step 2
    2
    Click the Data tab. It’s at the top of the screen.
  3. Image titled Connect Excel to an Oracle Database Step 3
    3
    Click Get Data. If you don’t see this option, click New Query instead.
  4. Image titled Connect Excel to an Oracle Database Step 4
    4
    Click From Database.
  5. Image titled Connect Excel to an Oracle Database Step 5
    5
    Click From Oracle Database.
  6. Image titled Connect Excel to an Oracle Database Step 6
    6
    Enter the Oracle server name into the ″Oracle Database″ box. This should be the host name or address of the server that hosts your database.
    • If the database requires an SID, use this format to type the server name/address: servername/SID.[2]
  7. Image titled Connect Excel to an Oracle Database Step 7
    7
    Enter a native database query (optional). If importing data from the database requires a specific query, expand the ″SQL Statement″ box by clicking the small triangle, and then type the statement.[3]
  8. Image titled Connect Excel to an Oracle Database Step 8
    8
    Click OK. This saves your options and initiates a connection to the database.
  9. Image titled Connect Excel to an Oracle Database Step 9
    9
    Log into the database. If the database requires you to log in, enter your username and password, and then click Connect. This connects the workbook to the database.
    • Depending on your settings, you may also have to choose an authentication method.
    • If you entered a native database query, the results will appear in a Query Editor window.

You Might Also Like

How to
Unhide Rows in Excel
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Open a Password Protected Excel File
How to
Open a Password Protected Excel File
Convert Notepad to Excel
How to
Convert Notepad to Excel
Download Microsoft Excel
How to
Download Microsoft Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Create a Drop Down List in Excel
How to
Create a Drop Down List in Excel
Add Links in Excel
How to
Add Links in Excel
Convert Excel to Word
How to
Convert Excel to Word
Run a Multiple Regression in Excel
How to
Run a Multiple Regression in Excel

References

  1. ↑ https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395
  2. ↑ https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395
  3. ↑ https://support.office.com/en-us/article/import-data-from-database-using-native-database-query-power-query-f4f448ac-70d5-445b-a6ba-302db47a1b00

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 62,785 times.
How helpful is this?
Co-authors: 4
Updated: August 21, 2019
Views: 62,785
Categories: Microsoft Excel
Article SummaryX

1. Click Data.
2. Click Get Data.
3. Click From Database.
4. Click From Oracle Database.
5. Enter the server name.
6. Enter a query (optional).
7. Click OK.
8. Log in to the database.

Did this summary help you?