>Try this:
>
>
>SELECT Table1
>COPY TO Text1 TYPE DELIMTED
>
>SELECT Table2
>COPY TO Text2 TYPE DELIMTED
>
>SELECT Table3
>COPY TO Text3 TYPE DELIMTED
>
>CLOSE DATA ALL
>
>CREATE TABLE Import (Temp M)
>
>SELECT Import
>APPEND MEMO Temp FROM Text1
>APPEND MEMO Temp FROM Text2
>APPEND MEMO Temp FROM Text3
>
>COPY MEMO Temp TO MyFile.Txt
>
>USE IN Import
>ERASE Import.Dbf
>
>
>Hope this helps
============================================================================

Thanks Kevin,

This may be a good idea with a few modifications that I will try;

DO WHILE as needed from the source tables
   SELECT SQL for the partial info I need in Table1
   COPY TO Text1 TYPE DELIMTED

   SELECT SQL for the partial info I need in Table2
   COPY TO Text2 TYPE DELIMTED

   SELECT SQL for the partial info I need in Table3
   COPY TO Text3 TYPE DELIMTED

   Append the 3 files as you said in the memo field IN IMPORT
ENDDO
CLOSE DATA ALL
USE Import
COPY MEMO Temp TO MyFile.Txt

USE IN Import
ERASE Import.Dbf