How to Connect Excel to an Oracle Database

How to Connect Excel to an Oracle Database
How to Connect Excel to an Oracle Database
Anonim

Learn how to connect an Excel workbook to an Oracle database using Power Query.

Steps

Connect Excel to an Oracle Database Step 1

Step 1. Open your workbook in Microsoft Excel

Power Query (in the Retrieve and Transform group) is a feature of Excel that allows you to easily connect a workbook to an Oracle database.

If you have not already installed the Oracle client software on your computer, you must do so before continuing. You can download the latest 64-bit version here and 32-bit there

Connect Excel to an Oracle Database Step 2

Step 2. Click the Data tab

It's at the top of the screen.

Connect Excel to an Oracle Database Step 3

Step 3. Click Get

If you don't see this option, click New request in place.

Connect Excel to an Oracle Database Step 4

Step 4. Click From Database

Connect Excel to an Oracle Database Step 5

Step 5. Click From an Oracle Database

Connect Excel to an Oracle Database Step 6

Step 6. Enter the name of your Oracle server

Type the name of your server in the Oracle Database field. This is the name or address of the server that hosts your database.

If a server ID (IDS) is required, you can specify it as follows: server name / IDS

Connect Excel to an Oracle Database Step 7

Step 7. Specify a Native Database Query (optional)

If it is necessary to specify a particular query to import data from a database, expand the SQL Statement box by clicking the small triangle, and then typing the query.

Connect Excel to an Oracle Database Step 8

Step 8. Click OK

Your options are then saved and the connection to the database is established.

Connect Excel to an Oracle Database Step 9

Step 9. Connect to the database

If you are asked to connect to the database, identify yourself with your username and password, then click To log in. The workbook is then connected to the database.

  • Depending on your settings, you can choose the appropriate authentication mode.
  • If you specified a native database query, the results will appear in the Query Editor window.

Popular by topic