sql - What's the table name for a defined name in the scope of a worksheet? -

i'm trying query defined name in worksheet scope sql using odbc.

i know works:

select * [worksheet1$]       -- query whole worksheet select * [worksheet1$a1:c10] -- query a1:c10 of worksheet select * myname              -- query workbook scoped defined name  

note myname workbook scoped , not worksheet scoped.

i have expected in excel formulas works odbc table name well:

select * worksheet1!myname   -- query worksheet scoped defined name 

however doesn't work, tried syntax variations of this.

is possible , if is, what's syntax use?

note delphi developers: a1:c10 syntax causes trouble in tadoquery, have set paramcheck false in order work.

update:

i'm using microsoft excel driver (*.xls, *.xlsx, *.xlsm, *.xlsb) version 12.00.6606.1000 comes microsoft office 2007.

i have checked delphi database components i'm using behaving same way microsoft query , microsoft access 2007.

try following figure out name delphi looking for.

1. drop combo box on form.
2. run following code populate combobox names delphi accept: adoconnection1.gettablenames(combobox1.items,true);
3. run app. combobox should give list of queryable names.

using delphi xe2 , office 2010 (excel file saved office 97 xls format) created worksheet scoped named range (sheet1!numberlist) , ran ado query in delphi. query select * [sheet1$numberlist]. maybe it's odbc driver?