Hi John, I agree with Fred - that Automation is one option. Although, I think that in doing so (which I HAVE done before) - there are a number of downsides to doing so (which others in the group have mentioned some of them in the past):
1 - The learning curve - if you've never done it before. 2 - The machine you run the program on must obviously have EXCEL on it to run. If someone was to try and run it - to produce the Excel file - to send that file to someone - they could NOT do it without Excel being on that machine. 3 - This also becomes a problem if the App runs on a server - which someone logs into - and the server does not have Excel installed. 4 - But, the main downside I have heard complains about from others - and experienced myself - is that this method is actually SLOW. Anyway - that's mostly an FYI and YMMV. Another option - look thru all the data you are about to export, and find the Maximum length of the content of the Memo fields to export. Then, if need be - convert it to Multiple Character fields. Hopefully that makes sense... Goodluck! -K- -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John J. Mihaljevic Sent: Wednesday, February 01, 2012 1:17 PM Hi all, I have a VFP table that includes (among other fields) two memo fields. The user wants to export the table to an Excel spreadsheet. Easy enough to do, but it doesn't take the memo fields. I considered copying the text to a character field, but because of the length limitation, it truncates the data. Is there a way to do this? Thanks! John _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140b7ce...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
