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
Niciun comentariu:
Trimiteți un comentariu