Is it possible to use MS query to query the dta in same sheet

[S K Srivastava]

I am trying to use MS query to query a list in MS Excel. So far I am not able
to do it. I want to know whether it is at all possible to query a table (or
list) in an excel sheet by using MS Query in same excel sheet or not?

 

[JCS]

Hi,

As far as I know you cannot. Try using Advanced Filtering, database
functions, or functions like Sumproduct to get the results you wish.

John

 

[Steve Kesler]

I have this working, however you have to treat your current work book as an
external ODBC data source. And, it has to point to the direct, fixed,
location the workbook file is located on your hard drive.

My ODBC connection string =
DSN=Excel
Files;DBQ=D:\Data\MLV\MasLoc_View_v1_32.xlsm;DefaultDir=D:\Data\MLV;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;


I would like to set the ODBC connection file to look for the Excel Table (or
named range) within the current workbook, and not rely on a fix file location.

Or be able to use MS Query to query data from within the current workbook.