This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi, I nedd to read data from excel using JDBC. When i give: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection"Jdbc:Odbc:ExcelDSN","",""); Statement st = con.createStatement(); Exception: I am getting Exception as:java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Please , tell me where i am doing wrong? Thanks
Thanks! I corrected it and now i am able to read data from excel.But,if i try to update data using St.executeUpdate("update [test$] set ENAME='updated' "); where st -statement object. I get exceptions as:Operation must be an updateable query. Is there anything with syntax?? Thanks
[This message has been edited by Naresh Babu (edited March 23, 2001).] [This message has been edited by Naresh Babu (edited March 23, 2001).]