restriction in the resultset string length

Hi

I was trying to make a jdbc-odbc connection to transfer data from an excel file to oracle and the query is

"Select Term,Definition from [Sheet1$]"

Most of it works fine except for the fact that the number of characters obtained in the second string (Definition) is restricted to 255 chars , and as such some of the definitions that are longer are abruptly cut out

Does anyone knows the work around for this ? is there any setting that needs to be changed

thanks

sharad

[526 byte] By [sharadm900] at [2007-9-26 6:22:09]