PC Review


Reply
Thread Tools Rate Thread

ADO.NET truncates excel data

 
 
Suresh
Guest
Posts: n/a
 
      19th May 2009
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel array truncates data Neil Microsoft Excel Discussion 3 6th Jan 2011 12:46 AM
data truncates when converting .csv to .xls =?Utf-8?B?c2VyZ2lv?= Microsoft Excel Misc 5 26th Nov 2005 01:32 PM
Access Report converted to Excel truncates data....IMPORTANT! =?Utf-8?B?c2FucG8=?= Microsoft Access Reports 0 20th Sep 2005 04:01 PM
my data truncates when ported from access to excel =?Utf-8?B?Q29uZnVzZWQgYWNjZXNzIHVzZXI=?= Microsoft Excel Worksheet Functions 4 13th May 2005 03:50 AM
Datagrid Truncates Data? Sean Microsoft VB .NET 9 6th Jan 2004 10:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:35 AM.