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