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)??

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)??