While pulling data from MS SQL and dumping it to a worksheet using the following code. It has worked until the (description field) exceeds 911 char. My question is is there indeed a 911 char limit. zConnectionString = _
"Provider=SQLOLEDB.1;Password=xxxxxx;Persist Security Info=True;" + _
"User ID=xxxxxx;Initial Catalog=xxxxxxxx;Data Source=xxxxxxxx;"

    zSQL = "select DISTINCT ProcBusCycle,CntrlName,ActnPlanName,ActnPlanDocTit le,ActnPlanDesc,ActnPlanCriticality,ActnPlanSteps, ActnPlanStatus,ActnPlanDueDate,ActnPlanResponse,Cn trlDesc,CntrlFrequency,CntrlType2 from ObjSrchTypViewActPlnProcRskMatCntrls Where OrgUnitName LIKE '%Intel%'AND ProcBusCycle NOT LIKE ('%Information%')"
    Set zConnection = New ADODB.Connection
    zConnection.ConnectionString = zConnectionString
    zConnection.Open
    Set zRecordset = New ADODB.Recordset
    zRecordset.CursorLocation = CursorLocationEnum.adUseClient
    zRecordset.CursorType = CursorTypeEnum.adOpenStatic
    zRecordset.LockType = LockTypeEnum.adLockBatchOptimistic
    Call zRecordset.Open(zSQL, zConnection, , , CommandTypeEnum.adCmdText)
   Call Sheet4.Range("A2").CopyFromRecordset(zRecordset)
   Set zRecordset.ActiveConnection = Nothing
   Set zConnection = Nothing

I have seen the exact same limitation when using the CopyFromRecordset method. 911 characters is OK, but 912 breaks.

I have been able to get around this problem by checking the string length and just truncating strings down to the correct size. That works well and doesn't slow you down too much.

Another thing that I have been able to get to work is to loop through the recordset one row at a time, and copy the data into each cell individually. This allows you to paste large strings into the cell, but it's not perfect either. Only the first 1000 characters (approximately) will be visible in the spreadsheet. All data is present in the cell as expected (when viewed in the formula bar), but not all characters are shown (even if the size of the cell/row is expanded manually) and only a certain amount (also about 1000 characters) appears in the printed form.

Sorry I can't help more, but I hope you can use what I've done to come up with a work-around.