While attempting to use CopyFromRecordset I ran into the 911 character
limitation mentioned in KB 818808.

http://support.microsoft.com/kb/818808/en-us

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?

Thanks.

*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

http://support.microsoft.com/newsgro...=en-us&m=1&p=1