problem using ado to insert record into excel table

[marktheman]

Anyone know is there a max column width allowable in Excel 97 when using the VB6 ado connection object to insert a record in a worksheet? I have no difficulty inserting a record if the text is a small amount of data but when I try and insert a large amount in a worksheet cell using

rs.Open "SELECT * FROM [tblCustomerSection$]", conn, adOpenStatic, adLockOptimistic, adCmdText
rs.AddNew
rs.Fields(0) = requestNoSubstringed

I get the following error "Data Provider or other service returned an E_Fail status"
I thought the max width of a cell was huge something like 65,000 but is there an issue here with cell width?
Thanks.

[theDude]

Hi Mark,

Column width: 255 characters

Length of cell contents (text): 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Refer to 'Excel specifications and limits' help topic for more...

Hope this helps,
theDude