Don, there are several ways to achieve this. My sugegstion would be to use the SCAN...ENDSCAN (or other loop mechanism) and output the data in a custom format that you require. For instance you could do any of the following:
1) Create a string containing all your required fields and then use STRTOFILE() to write the data out to a disk text file.
2) Open a file with low level file functions and write the data out to the file.
3) You can use a SET TEXTMERGE TO... and then TEXT....ENDTEXT and write out your data.
I'm sure that other UT members can think of even more options :)
>Thanks Jos!
>
>I now need to be able to export multiple records (Scan...EndScan) that have fields for part_id, bom description (Memo), book description (Memo), and various other numeric and logical fields. In otherwords, I need to be able to export data that contains all the normal fields combined with the contents of memo fields for multiple records into a single file.
>
>Any further help would be greatly appreciated! (Is this even possible?)
>
>Don
>
>
>>Don, You can use COPY MEMO MemoField TO FileName to get the memo data out into a text file. Then use Excel to read it in. Under Excel's File - Open set the file type to prn, csv, txt.
>>
>>
>>>Is there any way to "export to/copy to" the contents of Memo fields to type XL5? or any other available format?
>>>
>>>If so, please show me how or where I can find out how. I need this ASAP.
>>>
>>>I would appreciate any help with this.
>>>
>>>Thanks in advance!
>>>
>>>Don
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.