Hi,

I make an ODBC connection to an Excel Sheet from my java code and query the Excel like a DB.
The problem is certain cell values get read and for some cells it returns me null.

for eg:
if cell values are:
33626-2915
2466
89011-2401
90630-4356
30082

I notice 2nd and 5th rows return null.

Another interesting thing is that now if i delete all values from excel and re-write as this:

2466
33626-2915
89011-2401
90630-4356
30082

then in the above case only 1st and 5th row are read correctly.All others return null.
So all the values that are same in format like the first cell being read,will be read.All others will return null.

I cannot format all cells to xxxxx-xxxx format because this is the postCode.If I format it using Exel cell format of postCode the results are incorrect.30082 would be formatted to 00003-0082 which is not correct.
Also just the formatting doesnt work.It would still be read as null unless i copy the formatted column to a textpad and then copy it back to Excel.

Any solutions?