aspose file tools*
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: 7
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: 39551
    
  27
Let's continue the discussion in the original thread.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Numeric field overflow while reading excel sheet values in jdbc
 
Similar Threads
accessdata using excel
creating objects
Read Excel from JDBC.
Applet Reading from Excel Sheet
Read Excel from JDBC.