Reading more than 255 chars from Excel.

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.
 
M

Matthias Krug

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top