| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Excel file automatically opens | Excel Discussion (Misc queries) | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
