Excel CopyFromRecordset issue
Posted on 2010-08-26
I'm using Excel automation in a DCOM for my classic asp application and I am getting "Access Denied" error when one of the columns from the recordset has a very long string. I found that out when I change my Select statement to retrieve different date range and one of the result contained a long string. I am not able to find out what is the limit length of the Cell in MS automation object. However, I can put a very long string (10000 chars) in a interactive Excel sheet. This is happening in Excel 2003
My question is how to overcome this with minimal code change? The same function is still working under Excel 2000.