*
The moose likes JDBC and the fly likes Numeric field overflow while reading excel sheet values in jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Numeric field overflow while reading excel sheet values in jdbc" Watch "Numeric field overflow while reading excel sheet values in jdbc" New topic
Author

Numeric field overflow while reading excel sheet values in jdbc

Vishwanath Bannur
Greenhorn

Joined: Jan 07, 2008
Posts: 8
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
Marshal

Joined: Mar 22, 2005
Posts: 42612
    
  65
Let's continue the discussion in the original thread.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Numeric field overflow while reading excel sheet values in jdbc