While attempting to use CopyFromRecordset I ran into the 911 character
limitation mentioned in KB 818808.
The article does not provide a workaround, but there must be one since using
Tools > Import External Data or Microsoft Query in Excel does not produce the
same error using the same data. I attempted to copy the recordset to an
array, and then transpose and copy that array to worksheet, which was listed
as a possible method in KB 246335, but I got the same error.
So, the question remains, how does Tools > Import External Data do the same
thing as CopyFromRecordset without getting the 911 character limitation
error? Does anybody know a workaround?
*This post is a replacement for the post at the following link. The old post
wasn't getting any responses.
CopyFromRecordset fails if string > 911? in Excel Programming