Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to connect from excel to oracle db through oracle provider for ole db

949661Sep 20 2012 — edited Sep 20 2012

Dear experts,

I'd like to connect to Oracle db from excel via Oracle Provider for Ole DB. (using Windows 7 64bit, Office 2007, Oracle XE 32bit 11.2.0.2)
My Oracle XE database is installed locally on the same Win7 64bit machine where excel from which I want to connect to db.

However when I go to "Data Connection Wizard / Other/Advanced" it looks that Oracle Provider for OLE DB does not exist

The question is
1. whether I need to install additional ODAC package or maybe it is already included in the XE server version and need to be somehow activated
2. If ODAC installation is required which version should I choose (32 or 64 bit)?
3. Could you please provide the steps with information how to proceed (or links where can I read it)?

Thank you,
Kind regards,
Lukasz

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2012

Added on Sep 20 2012

#excel, #odbc, #xe

1 comment

1,406 views