Unable to access data from MS-Ecel sheet
Shivaranjan Guru
Greenhorn
Posts: 2
posted 13 years ago
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
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
