I needed it all in one field, so that didn't work for me. I don't know if it's any help to Brenda, who asked the question. CC her, if you didn't already.

Michelle


>The quick and dirty way to export is to turn the memo into a character field with a select statement:
>
>SELECT FLD1, FLD2, LEFT(FLDMEMO,250) AS MemFld INTO csrTest
>COPY TO xlfile XL5
>
>Note that you lose info if you have more than 250 characters in your memos (We dont).
>
>Or, saving a few bytes:
>
>CALC MAX(LEN(TRIM(fldMemo))) to lnMemLen
>SELECT FLD1, FLD2, LEFT(FLDMEMO,lnMemLen) AS MemFld INTO csrTest