ADO.NET truncates excel data
 

Hi all,
I've searched this all day but no use.

The problem is when I read a cell from Excel 2007 using ADO.NET the data is
truncated to 255 characters.

I'm using connection string:

Microsoft.ACE.OLEDB.12.0;Data Source=myfile.xlsx;Extended Properties="Excel
12.0 Xml;HDR=YES;IMEX=1"

I've seen posts on registry changes to fix this bug but they don't apply to
Excel 2007 and the ACE ole driver.

I should note that this doesn't always happen. On some files it's ok and in
others it's problem. This may have to do with the number of lines the driver
will scan to determine the data types.

Any help is appreciated. Any recommendations on posting this to other
forums would also be appreciated.

Thanks,
Suresh.