Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel truncates barcode being scanned in | Excel Discussion (Misc queries) | |||
Importing CSV into Excel sometimes truncates text at 256 characters | Excel Programming | |||
data truncates when converting .csv to .xls | Excel Discussion (Misc queries) | |||
my data truncates when ported from access to excel | Excel Worksheet Functions | |||
Excel range truncates when Pasted as Picture to PPT & Word | Excel Discussion (Misc queries) |