>>>It is probably a Monday morning blind spot
>>>
>>>I want to create a text file where the headings all alphabetic are on one dbf
>>>
>>>and the detail to go under the headings is a mixture of text, numeric and dates on another dbf
>>>
>>>Can I copy the data from the first file to a text file and somehow append the data from the second file to the same text file?
>>>
>>>Thanks
>>>
>>>
>>>Colin
>>
>>Sure,
>>Check STRTOFILE() function and especially last parameter :-)
>
>Thanks can you give me example code
>
>one.dbf has the text headings
>
>two.dbf has the data which should appear in the text file under the headings
>
>Thanks
>
>Colin

SELECT DBF1
COPY TO File1.TXT DLIMITED.....

SELECT DBF2
COPY TO File2.TXT DLIMITED.....

lcWholeStr = FILETOSTR("File1.TXT")+CHR(13)+CHR(10)+;
             FILETOSTR("File2.TXT")
STRTOFILE("FileName.EXT",lcWholeStr)