Hello,

I am experiencing a freak issue with copyFromRecorset when exporting data into Excel. I receive the OLE object or hierarchial recordset error message. After much debugging, I have concluded that the error seems to be with the total size of the data being exported. The stored procedure which returns the data runs fine in Query Analyzer, but when I try passing the data to excel I receive the above stated error message.

After removing many of the fields from the Stored Procedure and returning this cut down version of the data, CopyFromRecordset works perfectly. When cutting out fields, the entire recordset is returned (503 records).

Has anyone else ever experienced this type of problem? I am thinking that there may be a limitation on the Excel side of this equation.

Thanks in advance for any input you might have.