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
I get the following error "Data Provider or other service returned an E_Fail status"![]()
Please Login or Register to view this content.
I thought the max width of a cell was huge something like 65,000 but is there an issue here with cell width?
Thanks.
Bookmarks