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. _______________________________________________ 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/CACW6n4tO4hqnW82=AK=Jz_5QpWVgvGTCae3U_W=0dmg4azm...@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.
