View SQL Query without connection

[Colby]

Is there a way to see the SQL query that someone built in the query editor without actually having the ODBC connection installed on your machine? I assume the query syntax resides in the spreadsheet somewhere, not on the database it is querying.

I keep getting the error "[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified"

 

[StuLux]

In 2007 try going to Data, Connections, Properties and then on the 2nd tab you should be able to see the SQL?

 

[Colby]

Awesome, thanks. I forgot about that!