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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only