Thanks very much for all the replies! Yes, I could use COPY TO or EXPORT TO to take the raw data and send it out to Excel, but they have calculated reports they want this done with, and that's where things apparently get hairy.
It looks like I'm going to have to just use COPY/EXPORT and send their raw data to Excel and let them do whatever they need with it from there. Ideally, I could send their reports to Excel, but that just doesn't seem doable. Thanks again, all! -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: Wednesday, September 30, 2015 11:57 AM To: [email protected] Subject: Re: Exporting FPD DOS 2.6 reports to Excel On Wed, Sep 30, 2015 at 11:08 AM, John J. Mihaljevic <[email protected]> wrote: > > I haven't used this in forever, but a client with an old FPD DOS 2.6 > system wants the ability to export their reports to Excel. They don't > want any other changes, so bringing it up to VFP isn't an option. > > Is there a quick-and-easy way to make this happen? > My old project manager used to say, "Quick, Accurate, Cheap -- Pick Any Two." I all depends on what you're working with, and what the customer expects. If you used tables and relations and report variables and subtotals and totals and calculated fields, it's non-trivial to move that into Excel. I checked my copies of "Using FoxPro 2.5," (Slater & Arnott, Jacobsen, Gotthelf & Roche) and my "FoxPro 2.5 Programmer's Reference," (John Hawkins, Tamar Granor, Bill House, with Ted Roche as Technical Editor) and EXPORT TO XLS is in there. If you really still have a working FPD26 development environment around, it's not too hard. The worst parts are figuring out what you've got, what they want, and which of the several techniques is the easiest way to get there from here: 1. either COPY TO or EXPORT, to XLS. Excel should open it fine, but it's raw data. 2. Go the other way and copy a DBF or CSV of your results and then import them into Excel. You'll need to use ODBC drivers but you could load the data in to a predefined template form. 3. Run the FPD app in VFP. 99% of them run as is, though ugly as sin. 4. If you've got a fairly complex report, and clients want a lot of the calculations exported as well, the best way we've found is to do a raw export from Excel, and then a series of macros in Excel (which could be driven by a small VFP app if needed) to import, format, style, etc. But in exchange for high-fidelity, there's more upfront cost. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
