CopyFromRecordset (1 Viewer)

accessman2

Registered User.
Local time
Today, 11:36
Joined
Sep 15, 2005
Messages
335
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.
 

Users who are viewing this thread

Top Bottom