File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
Rancher

Joined: Mar 22, 2005
Posts: 42956
    
  73
Let's continue the discussion in the original thread.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Numeric field overflow while reading excel sheet values in jdbc
 
jQuery in Action, 3rd edition