Reading more than 255 chars from Excel.

  • Thread starter Thread starter Durango2008
  • Start date Start date
D

Durango2008

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.
 
Durango2008 said:
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.
Click to expand...

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.
 
Back
Top