• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Numeric field overflow while reading excel sheet values in jdbc

 
Vishwanath Bannur
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:



-Vishwanath
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Let's continue the discussion in the original thread.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic