>How can I export a memo field data to fixed length text file?
>
You can first convert memo field into character field and than copy result cursor into text file.

SELECT field1, field2, ..., LEFT(Fieldmemo,254) ;
  FROM mytable ;
  INTO CURSOR crsTemp
COPY SDF TO (lcTextFile)