Hi all I am having problems connecting to Excel files through ODBC my code compiles perfectly but when I run it gives me the following error: java.sql.SQLException: [Microsoft][ODBC Excel Driver] Could not find installable ISAM. please helpme out. It happened to me once when I was using VB to connect to an excel file I re-installed visual studio in which I check the ISAM tabs in the DATA access dir if any body can help me out on this Thanks Farooq
posted 14 years ago
Try something like: Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); c = DriverManager.getConnection( "jdbcdbc:excel_dsn", "", "" ); stmnt = c.createStatement(); String query = "select * from [main$] where [Field1]='Test';"; ResultSet rs = stmnt.executeQuery( query ); With a DSN of "excel_dsn" pointing to your Excel workbook file.