Jos,
I appreciate your help! Rick Bean pointed me to some code online that essentially does what you described. After some tweaking, I finally got it to work the way I needed.
Don
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only