Error when field exceeds 255 chars using ADODB.Recordset with ACE Excel 8 adodb version 6.1

[MichaelinSeattle]

I've created a tool that works creating Excel subsets worksheets of lager Excel worksheets.

My OS is windows 7
Here is the connection info:

Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & SourceXLSX & ";" & _
"Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"""

This has worked for 16 months until this week when one of the fields (cells) contained over 255 chars.

I remember a problem with the Jet engine, but I thought it was fixed in the ACE engine.

All of the post I've found deal with the JET engine and or older versions of Excel.

I did find one MSDN reference to a similar bug and the solution was to install a SP for ADO called MDAC_TYPE.EXE

It seems to be for older versions of ADO and I wanted to check to see if any of you have run into this issue using a similar system configuration.

Any help would be great.

--Michael

 

[anvg]

I had no any error with cells contained over 255 chars (411). But If long-text cells are end of a sheet's table their values are truncated to 255 chars. After I sorted the table for moving long text cells to top of the table. A recordset returned right length of cell's values (len(411).
Regards,