How to Connect to Oracle from VBA/Excel on 32bits and Windows on 64bits

Precondtion:

Client Machine configuration: Windows on 64bits and Microsoft Office on 32bits

Stepts to configure access to Oracle from VBA/Excel

1. Download 32bit Oracle Client “ODTwithODAC121010.zip” from here http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

2. Install Oracle Client, follow wizard steps, when creating tnsnames.ora specify oracle connection details

3. Add Environment User Variable with name TNS_ADMIN and value "D:\app\haneefaa110\product\12.1.0\client_1\Network\Admin " – path where the TNSNAMES.ORA file is located

4. Open ODBC 32bit version from here C:\Windows\SysWOW64\odbcad32.exe

5. Create user DNS connection with the name “wpsit32” and test the connection

6. Open Excel file

7. Go to Menu->Data->From Other Sources->From Microsoft Query, select the DNS connection from 

step 4

8. Run your SQL query