"TK" wrote ...

I have written a VB program to read the excel file via ADO.
ie :
rs.Open "SELECT * FROM [sheet1$]"

However, I find that if the excel cell contains more that 255
characters,
the recordset cannot retrieve it correctly, it will store the first 255
character and discard the rest.

Is it a ADO Excel provider limitation ?
anyone idea to solve this problem ?

Sounds like Jet is determining the column's data type as 'text' rather
than 'memo'. For details see:

http://www.dicks-blog.com/excel/2004...al_data_m.html

Jamie.

--