>>>>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)
>
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing