Oracle ODBC x86 and x84 on Excel 32bits.

I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(11.2.0.1) ODBC driver on my Excel.

I have Office 365 32bits installed and need to use the Provider=OraOLEDB.Oracle but when i try to connect i have a error who says i can't connect to the DB.

I do not understand why. The Office can't use the 32bit OLEDB dll, since i aready have on my system ?

Is possible to specify whats plugin to use on the Excel connection string ?

Another thing, when i try to do a TNSping, is possible to specify the Oracle 11 32 bits TNS ping utility instead the default 12c 64bits ?

0 answers