ODBC ListObject / ODBC named range

[lalbatros]

Hello,

ODBC on Excel files makes it possible to access a WorkSheet as if it was a table in a database.
This is done by naming the table with square brackets and a dollar, like this: SELECT customer FROM [Sheet1$] .

What I really would like to do is accessing a ListObject as if it was a table in a database.
Alternatively, I could be happy by accessing a named range.

Would you know how to do that?

My guess is that ListObject might not be available to ODBC, as this is a recent feature and ODBC is an old feature.
However, named ranges should be possible ... as names are old in Excel.

Thanks for your suggestions,

Michel

 

[RoryA]

Named ranges are accessible as long as they aren't dynamic.

 

[lalbatros]

Interesting!
How can I access Named Ranges via ODBC?
Where is that documented?
Michel

 

[lalbatros]

Just found how simple that was.
SELECT customer FROM myNamedRange.

Thanks

 

[Fazza]

shouldn't be necessary, but for info more robust is alternative

SELECT ...
FROM [myNamedRangeEnclosedInBrackets]