reading an Excel file from java application

[marys joseph]

Hi all,

I have to read from excel file and update a tbl in sql server.

Partial code is :

 try {
      Class.forName(DRIVER_NAME);
      //Connection conn = null;
      conn = DriverManager.getConnection(DATABASE_URL);
      stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from [sheet1$]");
      int i = 0;
      while (rs.next()) {
 
        // this is the total lengeth of the excel file
        if (i <= excelRows) {
 
state = rs.getString(3);
idnumber = rs.getString(4);
 renew = rs.getDate(5);
 ssn = rs.getString(6);

Problem I have with this code is
1)it does not read the first row
2)idnumber has numeric, alpha and alphanumeric values. If the second row has numeric value then if it returns null for rest of the alpha and alphanumeric value. If the second row has alpha value then it return null for the numeric and alphanumeric values.

Any ideas to resolve this problem?

Thanks