Hi All Pls help me where i am wrong i am coding as below for
testing the connection and
applet and excel,i get error while making the dsn connection that is in DriverManager.getConnection("jdbc
dbc:Excel Files"); as below.
java.sql.SQLException: No data found
Excel Files dsn is default user dsn in odbc for Excel. i even tried by making a new system dsn and user dsn even then i get the same error can any one guide me. pls it is urgent.......
import java.sql.*;
public class excelWrite
{
public static void main(String args[]) {
Connection conn=null;
Statement stmt=null;
String sql="";
ResultSet rs=null;
String srno="10";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println(" "+Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"));
conn=DriverManager.getConnection("jdbc
dbc:Excel Files");
stmt=conn.createStatement();
//sql="INSERT INTO [Sheet1$](srno,test,description,output,output1,pass) VALUES ('1','Hari','Venke','Vasan','Swami','Shalin')";
//int i =stmt.executeUpdate(sql);
}
catch (Exception e){
System.err.println(e);
}
finally {
try{
rs.close();
stmt.close();
conn.close();
rs=null;
stmt=null;
conn=null;
}
catch(Exception e){}
}
}
}
dbc:JavaExcel","","");