A question that involves Excel 2010 oracle odbc

Asked By 30 points N/A Posted on -
qa-featured

Hi everyone,

I want to use Excel 2010 to Oracle ODBC to query data, but I don't want to install the Oracle Client through ODBC.

Is there an easy solution to this problem?

Can some one tell me how to do this?

Any help at all would be excellent,

Thank you.

SHARE
Answered By 0 points N/A #173173

A question that involves Excel 2010 oracle odbc

qa-featured

Hi,

   It's a simple procedure, please follow the below steps:

1. Click the data connection wizard item.

2. Click the Advanced option to connect Oracle DB.

3. Choose the provider for OLE DB. (can download from here,if not provided)

4. Choosing next, then in connection tab, provide details.

5. Verify the connection (Test). Then click OK.

6. Data Connection wizard pops up now, pick the any desired table for access within the PL/SQL schema.

   (Click next)

7. Select finish, and start importing data.

Login/Register to Answer

Related Questions