• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to access data from MS-Ecel sheet

 
Shivaranjan Guru
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic