Cannot get to SQL Query in Excel 2003 bvj 04.12.2005 17:41:02 I’m using Excel 2003. I’ve been given an Excel file that contains a worksheet with an SQL query. I do not know what the datasource is nor any details about the query itself. When I click on “Edit Query” or “Refresh Data” or “Refresh All”, this error message is always returned “[Microsoft][ODBC Driver Manager] Driver does not support this function” and I am not able to access the query. No information is returned regarding the unsupported function. I’d like to be able to at least get to the query so that I can see what’s there and work on it to try to fix the problem. Do you have any ideas on how I an access this query?

Re: Cannot get to SQL Query in Excel 2003 Bill Manville <Bill-Manville[ at ]msn.com> 05.12.2005 08:21:53 Cursor in the query results. Alt+F11 to the VB editor Ctrl+G to the immediate window ?ActiveCell.QueryTable.SQL will give you the SQL of the query ?ActiveCell.QueryTable.Connect will give you the connection details. Bill Manville MVP - Microsoft Excel, Oxford, England