Hi Kurt, In regards to the speed issue of automation, I agree. One way around that is to use _VFP.DataToClip() and paste into the Excel activesheet, then "cleanup" the spreadsheet as needed to remove field header rows, etc. Memo fields don't come across via this method, just Memo shows in the cell. You could then process just the memo fields via automation and it wouldn't be too bad. Definitely not as slow as trying to process ALL fields via automation. Again, YMMV depending on lots of things as you've pointed out.
Fred On Wed, Feb 1, 2012 at 2:46 PM, Kurt Wendt <kurtwe...@waitex.com> wrote: > 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 > [excessive quoting removed by server] _______________________________________________ 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/cajcbksqshagpk5nhuzqzrtth4vpynn1qxsfkanh2xgosgwk...@mail.gmail.com ** 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.
