Brenda,
If you have an understanding of OLE Automation, I believe that would be the way to go. I know from experience that it does copy the memo fields just fine. There is an obvious speed loss between the simple COPY TO, and using automation, but the tools that become available to you are much greater too.
Hope this helps guide you in the right direction.
Paul A. Busbey
Victoria Insurance