Connect Excel to Oracle through ODBC

16 Aug

Steps to setup:

  1. Install Oracle client http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
  2. Install odbc http://www.oracle.com/technetwork/topics/winsoft-085727.html
  3. Use the odbc administrator in the syswow64 directory to create a DSN pointing to oracle

 

 

4. Configuring Excel to Connect to Oracle

Open a new book or sheet in Excel. Follow the Data>Import External Data>Import Data path to select a data source. Highlight +Connect to New Data Source and click Open (or double-click it) to bring up the Data Connection Wizard.

 

 

 

 

 

 

 

 

 

 

 

 

Useful links:

http://www.databasejournal.com/features/oracle/article.php/10893_3358411_1/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm

https://forums.oracle.com/thread/2558996

https://forums.oracle.com/message/10703232

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: