Reading more than 255 chars from Excel.
 

Hello, I am kind of in a bad situation.
I am trying to read data out of Excel using OLEDB, however any data more
than 255 characters gets truncated.
I found out that this is a known issue and that the solution requires
fiddling with the machines registry.
I cannot change registry of the server b/c I am not admin and I don't think
I can have it changed at all regardless.
Is there a way to get around this w/o changing registry?
I've been stuck with this for a couple days now, and trying to find a good
solution.
Any help is appreciated, thank you.

Reading more than 255 chars from Excel.
 

Durango2008 schrieb:
I am trying to read data out of Excel using OLEDB, however any data more
than 255 characters gets truncated.
I found out that this is a known issue and that the solution requires
fiddling with the machines registry.

In a similar situation I got all text fields truncated at the 256th
position. I escaped that situation by using the ODBC-driver instead of
the OLE-DB driver.