I have a connection between Excel and Access which is/was working fine, so I thought, but I've just discovered my recordset items are no longer than 256 characters.

Please don't tell me this is a max limit, and much of my stuff is longer.

My connect string is

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & theName & ";" & _
"extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"

and Cursor types

rx.Open sql$, cnn, adOpenStatic, adLockReadOnly

Can I get round this anyhow - please? !

Thanks, ABB