Excel 2007 "Tables" Reference with oledb?
 

Hello All,


I want to use both Access and Excel (both 2007) to query Excel 2007
workbook "tables."

I do have luck with syntax like:

"select * from [mysheet$]

or

"select * from [mysheet$mylocalname]

or

"select * from [myglobalname]

but I can't seem to reference "tables"

The following does not work:

"select * from [table_mytable]"

where "table_mytable" is an Excel table

Any ideas?

Thanks!