Forum Discussion

M_McDonald's avatar
M_McDonald
Super Contributor
14 years ago

JDBC DataSource to Excel

Hi - I can connect to a spreadsheet with JDBC like this: Connection c = DriverManager.getConnection( 'jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:/test.xls'); Statement stmnt = c.c...
M_McDonald's avatar
M_McDonald
Super Contributor
14 years ago
Hi Robert-

Actually I was trying to get help on configuring the DataSource itself, the standard JDBC-ODBC driver setup doesn't seem to lend itself to this.

Thanks.

- Michael