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 getting data from Excel 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 "getting data from Excel" Watch "getting data from Excel" New topic
Author

getting data from Excel

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
I am trying to read records an excel file and insert into
Oracle database using
jdbc dbc:excel driver.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
excelCon = DriverManager.getConnection
("jdbc dbc:exceldsn");
Statement excelStmt = excelCon.createStatement();
I kept my data in the first sheet.So I read data using the
command
excelRs=excelStmt.executeQuery("select * from [Sheet1
$]");
I read the data in the columns using the command
excelRs.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.
I formatted all the cells in the excel sheet uniformly using
all the categories.But none helped me.
The pattern in which this happens is not unique.
for example if the first column of my excel sheet has the data
a
2
2
2
2
2
the format for these columns is Text as in format cells
options.
In this example I get null,2,2,2,2,2 as results when I try
to read using
getString method of ResultSet.
but some times I do get the correct result without changing
the code but changing the
data in the excel sheet.
Any ideas?

SCJP 1.5, SCEA, ICED (287,484,486)
Matthew X. Brown
Ranch Hand

Joined: Nov 08, 2000
Posts: 165
I don't see any resolution to your problem. I'm having an identical problem, with zero resulting in a null in the result set. Did you resolve the issue, or did you simply reformatt/manipulate the data?
 
Consider Paul's rocket mass heater.
 
subject: getting data from Excel
 
Similar Threads
EJB and Excel Urgent
Apache Excel api
JSP/HTML to Excel
Numeric field overflow while reading excel sheet values in jdbc
Jdbc with MS-excel