poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: Reading XLS via ODBC - SQLException
Date Wed, 05 Feb 2003 18:40:10 GMT
Sorry jumped to conclusions ;)

It looks like a poi file format issue.  your program works with the file 
i made from excel.  i guess poi doesn't spit out the records the way the 
ODBC driver expects it.


Eric Hsiung wrote:

>>I'm sorry Eric, I just created an Excel '97 spreadsheet and 
>>it still had 
>>this error.
>>I used the 5/4/2001 drivers so maybe they have a newer version to 
>>correct this but in the meantime you have a workaround.
>Sorry, I don't understand. You created the spreadsheet using
>Excel or Poi?
>My ODBC Excel driver is from 7/22/2002 but I don't think
>it is an ODBC issue. Well, not directly. There is something
>about the Poi-generated XLS file that is tripping up ODBC.
>If I load the Poi-generated file directly into Excel and save
>it, then my test program works fine.
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org

View raw message