hi, When i try connecting to MS-Excel worksheet , its giving the below error : java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. The code i 'm using is Connection con = java.sql.DriverManager.getConnection( "jdbc dbc:Test" ,"",""); Here Test is the System DSN already created which points to the excelsheet i want to read.. cud neone help me..plz
So I left, I came home, and I ate some pie. And then I read this tiny ad:
dbc:Test" ,"","");