hi:

I use CopyFromRecordset to export the data to Excel worksheet. I have error message.
I have one field column which stores message/comments, there is one message/comments is very long, like 6-7 lines long. This record affect to export data to Excel using CopyFromRecordset function.

How do I fix this?

I want to use CopyFromRecordset, because I want to design the worksheet style, eg. draw the line, do some format of the worksheet.