Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Unable to access data from MS-Ecel sheet

Shivaranjan Guru
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!