Home |
Search |
Today's Posts |
#1
Posted to comp.lang.java.databases,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to comp.lang.java.databases,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to comp.lang.java.databases,microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to comp.lang.java.databases,microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to comp.lang.java.databases,microsoft.public.excel.programming
|
|||
|
|||
Reading long strings (with jdbc) from Excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcard MATCH() breaks on long (?) strings | Excel Worksheet Functions | |||
Filter long Text strings | Excel Worksheet Functions | |||
Best structure to store a long list of strings? | Excel Programming | |||
Best structure to store a long list of strings? | Excel Programming | |||
Enhancing performance of excel jdbc: odbc driver | Excel Programming |