| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing SQL when MSQERY cannot attach to DB
I have a couple worksheets with complex queries where the database is no
longer available. All I need to do is to open up the query (MSQUERY) so I can view the sql to recreate the query pointing to a new database. HOWEVER, Msquery seems to require that I be ableto access the database before it will open, thus allowing me to view the sql. how can I get around this msquery behavior to see the sql (or just open)?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
viewing SQL when MSQERY cannot attach to DB
Sqlboy
http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn you can change the Connection and CommandText properties through code. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com SQLboy wrote: I have a couple worksheets with complex queries where the database is no longer available. All I need to do is to open up the query (MSQUERY) so I can view the sql to recreate the query pointing to a new database. HOWEVER, Msquery seems to require that I be ableto access the database before it will open, thus allowing me to view the sql. how can I get around this msquery behavior to see the sql (or just open)?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to attach doc.to an email? | New Users to Excel | |||
| Attach code | Excel Worksheet Functions | |||
| Attach a Help Text With A UDF! | Excel Discussion (Misc queries) | |||
| attach files | Excel Worksheet Functions | |||
| Can I attach a PDF in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
