Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: "Reference is not valid" when refreshing pivot table | Excel Discussion (Misc queries) | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Excel 2007 PivotTable "arbitrary shape is not allowed when its elements cross a reference dimension" | Excel Discussion (Misc queries) | |||
Excel VBA - go to worksheet "name" based on a cell reference ="Name" | Excel Programming |