Querying Excel 2007 Workbook with JDBC/ODBC

Question

Hi,

I've created an ODBC connection to an Excel 2007 Workbook using ACEODBC.dll, which is supposed to work for both .xls and .xlsx files. However when I try to open a connection using JDBC I get a SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. The Workbook is also password protected and encrypted, which may be the issue here.

The connection String is of the form jdbc:odbc:filename;pwd=password.

Any suggestions will be much appreciated.

Thanks,