Numeric field overflow while reading excel sheet values in jdbc

[Vishwanath Bannur]

Hi all,
I am reading excel sheet values from jdbc.

I read the data in the columns using the command

ResultSet.getString(1);

this returns me the data correctly when ever I keep uniform
data in the excel sheet
like either numbers or characters.

But it is returning me null when data is mixed with numbers and characters alternatively.


for example if the first column of my excel sheet has the data

Cols(1)
abc
222
222
fga
243
266

Its giving error as [Microsoft][ODBC Excel Driver] Numeric field overflow.

Please please help me if any one knows the solutions.

My java code:

 try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
con = DriverManager.getConnection("jdbc :-o	 dbc :mrgreen: river={Microsoft Excel Driver (*.xls)};DBQ=" + filename);
System.out.println("Get connection");
//con = DriverManager.getConnection("jdbc :-o	 dbc:ExcelTest","","");
stmnt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

rst=con.getMetaData().getTables(null, null, "%", null);
rst.next();
String SheetName = rst.getString(3);
String query = "Select * from ["+SheetName+"]"  ;
rs = stmnt.executeQuery( query );
ResultSetMetaData rsmd = rs.getMetaData();
int ColCount = rsmd.getColumnCount();
    
if (rs!= null)
{
rs.last();
totalRecords= rs.getRow();
rs.beforeFirst();
System.out.println("Total Records from Excel Spreadsheet" + totalRecords);

if(totalRecords > 0)
{
PONum = new String[totalRecords];
POVersion = new String[totalRecords];
BillingTelNum = new String[totalRecords];
while (rs.next())
{
String pon = rs.getString(1);
if(null!=pon)
{
PONum[i] = pon;
}
else
PONum[i] = null;
String pov = rs.getString(2);
if(null!=pov)
{
POVersion[i] = pov;
}
else
POVersion[i] = null; 
String telnum = rs.getString(3);
if(null!=telnum)
{
BillingTelNum[i] = telnum.substring(0,telnum.indexOf("."));
}
else
BillingTelNum[i] = null;
}
}
}
catch(SQLException sqle)
{
sqle.getMessage();
}
catch(Exception e)
{
System.out.println(""+e.toString());
}
finally
{
try
{
rst.close();
rs.close();
stmnt.close();
con.close();
}
catch(Exception e)
{
System.err.println(e);
}   

-Vishwanath

[Ulf Dittmer]

Let's continue the discussion in the original thread.