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