Connect Excel to Oracle through ODBC

16 Aug

Steps to setup:

  1. Install Oracle client
  2. Install odbc
  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:




Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: