ADO.NET truncates excel data

S

Suresh

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.
 

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

Similar Threads

Problem in Excel 2007 when Range beyond 65536 in SELECT statement 2
Accessing Excel 2007 from Visual studio 2005 on Windows 7 machine 0
export excel data to access table using ADO 0
Importing .xlsm, .xlsx with OLEDB 5
ADO connection to a protected workbook? 3
Excel 2007 connection via oledbconnection 2
Problems starting Word from Excel VBA 3
reading excel 2007 returns 255 columns! 3

Top