Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export contents of Memo field to type XL5
Message
From
28/01/2003 13:04:14
 
 
To
28/01/2003 11:32:36
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00746200
Message ID:
00746303
Views:
24
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
Map
View

Click here to load this message in the networking platform