Reading long strings (with jdbc) from Excel
 

Hi,

I'm not sure whether this is a jdbc/java problem or an excel problem.
I use RmiJdbc to read from an Excel file as a database. In one of the
columns I have "long" strings (over 255 characters). When I try to
read them through JDBC I only get the first 255 (or 256) characters.

I use result.getString("Description"). But have also tried
result.getCharacterStream("Description") and reading the string from
the stream. In either case, I don't get the entire string.

Thanks,


Aaron Fude

Reading long strings (with jdbc) from Excel
 

you'll probably need to set IMEX=1 in the extended properties of the
jet connection string..

see Dick Kusleika's blog for more on the subject of mixed datatypes.
http://www.dicks-blog.com/excel/2004...al_data_m.html





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Aaron Fude wrote :

Hi,

I'm not sure whether this is a jdbc/java problem or an excel problem.
I use RmiJdbc to read from an Excel file as a database. In one of the
columns I have "long" strings (over 255 characters). When I try to
read them through JDBC I only get the first 255 (or 256) characters.

I use result.getString("Description"). But have also tried
result.getCharacterStream("Description") and reading the string from
the stream. In either case, I don't get the entire string.

Thanks,


Aaron Fude

Reading long strings (with jdbc) from Excel
 

I haven't tried this yet, but from your answer I'm guessing that it is
an Excel issue rather than jdbc. Just out of curiosity, in my sql
code, why can't I simply say result.getMemo()?

Also, from the post it is not clear what IMEX is. Is it a registry key
in the same section as the other discussed keys?

Thanks,


Aaron Fude

Reading long strings (with jdbc) from Excel
 

IMEX is an (extended) property of the connection object.
read the page i referred to for a discussion of it's implications


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Aaron Fude wrote :

I haven't tried this yet, but from your answer I'm guessing that it is
an Excel issue rather than jdbc. Just out of curiosity, in my sql
code, why can't I simply say result.getMemo()?

Also, from the post it is not clear what IMEX is. Is it a registry key
in the same section as the other discussed keys?

Thanks,


Aaron Fude

Reading long strings (with jdbc) from Excel