Which Oracle Client do I need to Install to Connect Excel to Oracle?
Posted on 2011-05-13
I would some help to connect Excel to Oracle.
I am using Excel 2007 (32-bit) on Windows Vista Enterprise 64-bit. I want to connect to an Oracle 10g database through our local network using ODBC. I need to fetch some data once into a sheet and then the rest of the calculations would be done in Excel.
There are no firewall issues as I can connect from my machine, using SQL developer as a local client to the Oracle Database.
I tried to make an ODBC connection but Oracle is not listed as a driver.
I downloaded a 587 Mb file from oracle called win64_11gR2_client.zip
I'm reading the documentation and having problems choosing.
Which installation do I need: Install Client or Install Client Light, or Administrator, Runtime or Custom?
Do I need to install a 64bit client to access my Oracle Database ?
Can I use the 11G Client to access a 10 G database ?
Is ODBC the best way to do this?
Thanks for all your help, in advance.