I need a solution for the following question urgently. I
hope any of you will give me the best solution.
I am using JDK 1.3.1 and the JDBC-ODBC bridge to retrieve data
from an Excel spreadsheet provided by a user. The spreadsheet
is created manually be the user, not by inserting data via JDBC.
A given column of data contains both numeric and alpha-numeric
data. When I encounter a row that has strictly numeric data,
the data is not returned in the query.
Example:
14A
B192
2349
16-9
Data is returned for 14A, B192, and 16-9, but 2349 returns a
null.
Note: If I CREATE the data in a spreadsheet via JDBC, I do not
have any problems retrieving numeric data. Only when the user
has entered the data does it pose a problem.