vineri, noiembrie 08, 2013

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


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 “” from here

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

Niciun comentariu:

Trimiteți un comentariu