Need help Connecting to Excel (driver problem)

[Farooq Ali]

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]

Try something like:
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c = DriverManager.getConnection( "jdbc:odbc: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.