M_McDonald
14 years agoSuper Contributor
JDBC DataSource to Excel
Hi -
I can connect to a spreadsheet with JDBC like this:
How can I configure a JDBC DataSource to access an Excel file I specify dynamically?
Thanks.
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.createStatement();
String query = 'select * from [Sheet1$];'
ResultSet rs = stmnt.executeQuery( query );
rs.next()
log.info ( rs.getString( "Name" ) )
How can I configure a JDBC DataSource to access an Excel file I specify dynamically?
Thanks.