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
Lee Wallen
Greenhorn
Joined: Jul 14, 2001
Posts: 10
posted
0
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.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: Need help Connecting to Excel (driver problem)
0
dbc:excel_dsn", "", "" );