viewing SQL when MSQERY cannot attach to DB

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Defined Function not allowed in Excel Query of Access DB? 4
Vista - Msquery MsExcel and SQL data works in XP but not in VISTA 2
Running a SQL query off an excel table of data 1
Prompting for parameters in MSQuery to pass into a stored procedure 4
SQL View 5
ODBC parameter query fails with HAVING 1
Excel tables vs. system tables 3
Can't create a report from my query in Access 1

Top