Product: Aqua Data Studio
Version: 12.0.8
Build #: 30184
Build Date: 2012-Nov-15 11:39:59 AM
Operating Environment: Windows XP (5.2, x86) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10
Memory: Max=766,312,448; Total=211,169,280; Free=88,854,208; CPUs=8
1. ensure you have an ODBC connection to an XLSX file
2. launch a query analyzer on the ODBC connection
3. type a select statement like
select * from
and let autocompletion show you the worksheet name and pick that worksheet
4. your select will look like
select * from 'Grid Results$'
5. attempt to execute that select and you will get
>[Error] Script lines: 1-2 --------------------------
[Microsoft][ODBC Excel Driver] Syntax error in query. Incomplete query clause.
[Executed: 11/15/2012 2:06:11 PM] [Execution: 0ms]
6. Alter your query so the worksheet name is surrounded by [ ] instead of single quotes, like
select * from [Grid Results$]
7. execute that and you will get results in your grid/text results.
see attached for the XLSX file I used, the .conn file for this connection and screenshots of my ODBC Data Source information
Niels says this isn't a bug