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
posted 14 years ago
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?