This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 41060
    
  43
Let's continue the discussion in the original thread.


Ping & DNS - my free Android networking tools app
 
wood burning stoves
 
subject: Numeric field overflow while reading excel sheet values in jdbc
 
Similar Threads
Read Excel from JDBC.
Read Excel from JDBC.
accessdata using excel
Applet Reading from Excel Sheet
creating objects