Robin,

Take a look at this thread - MESSAGE #844067 - COPY TO an Excel - including Memo fields.

-Dan

>I'm using COPY TO to transfer data from a table into a spreadsheet, but of course the memo fields don't get transferred.
>
>What's the best method for getting around this?
>
>Is the only way to use Office Automation to achieve this?
>
>TAI