I assumed "ong" was using an older version and was having trouble returning
the last character. I stand corrected or amended.

Good Luck
TK


"Tom Ogilvy" wrote:

A cell can contain approximately 32K characters in xl97 and later.

--
Regards,
Tom Ogilvy


"TK" wrote in message
...
Hi
A cell can contain up to 256 chrs. If you are reading 255 the VB control
you
are using is probally set to o index. Most VB controls can be set to
either 0
or 1 as the starting index number.

Goog Luck
TK



"ong" wrote:

Hi all,

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 ?

Thanks