Version: 14.0.3-4
Build #: 34540
Build Date: 2013-Oct-24 10:17:24 AM
Operating Environment: Windows XP (5.2, x86) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_43-b01
Memory: Max=766,312,448; Total=197,345,280; Free=97,963,208; CPUs=8
Generic ODBC to an Access 2007 .mdb file (see attached for sample db)
1. right click on a MS Access Generic ODBC connection and choose Tools > Export Tool
2. select Tables and check just the table desired ( Table1 )
3. click to export to CSV and click next
4. the following error is generated
Export started ...
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\._ꌰꍶᛉꑛ const extends.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.j᠙ꃝꉗꉧ long finally.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.j᠙ꃝꉗꉧ long finally.run(Unknown Source)
Export completed.
It is possible to get a successful export if you choose Export From Select and use the following query
select * from "Table1"