ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   How to update ORACLE query definition in Excel file (https://www.excelbanter.com/links-linking-excel/63600-how-update-oracle-query-definition-excel-file.html)

Viks

How to update ORACLE query definition in Excel file
 
I have an excel file with several queries.

This is connection string.
It is saved in Excel file UID and PWD.
I can see it using this macros.
http://support.microsoft.com/kb/330383/en-us

Connection -- ODBC;DRIVER={Oracle73 Ver
2.5};UID=MYNAME;PWD=MYPASS;DBQ=PROD;ASY=OFF;
CommandText -- SELECT USERS.NAME FROM SCHEMA1.USERS

How to update CommandText SCHEMA1 with SCHEMA2 in above query?



All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com