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