Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in retrieving data from MS Excel sheet

843854Jan 31 2002 — edited Feb 7 2002

Hi .
I am reading an excel file by jdbc:odbc connection.While retrieving the data i am using the method resultSet.getString(column); But the problem is that if any column (say column 2)has data as String at any row(say row 3 column 2) and data as number e.g 345 in another row(row 5 column 2) then the method

resultSet.getString(column);

is returning value null for the row 5 i.e row containing numerical data,time data etc.The data type of all the column is Text(Varchar) Can any one help me how to retrieve data from a column of Excel sheet having such datas. I have used getDouble() and all other methods of resultSet also. For more information i should say that datatype of meta data is VARCHAR(=text)
Regards
Aminur

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2002

Added on Jan 31 2002

#java-database-connectivity-jdbc

1 comment

155 views