Thread: Reading more than 255 chars from Excel.
View Single Post
  #2   Report Post  
Posted to microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.framework.aspnet,microsoft.public.dotnet.languages.csharp,microsoft.public.excel.programming
Matthias Krug Matthias Krug is offline
external usenet poster
  
Posts: 1
Default 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.

Reply With QuoteReply With Quote