Actually - the question was already answered - and the complication is that the Customer wants the Excel to be formatted like a Report w/Sums & other Junk. As such, can't be solved by a simple export like you mentioned.
As for Tom - he was a Great Chap - I met him back in 1989 at the 1st Fox SW conf. put on by Fox SW. -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: Wednesday, September 30, 2015 2:18 PM To: [email protected] Subject: Re: Exporting FPD DOS 2.6 reports to Excel Happen to have my Tom Rettigs FoxPro Handbook handy!. There is an option to "copy to type" Here's the syntax; COPY TO <txt filename> | (<C txt filename>) [TYPE] FOXPLUS | SDF | DELIMITED [ WITH <delimiter> | BLANK | TAB] [FIELDS <field list> ] [<scope>] HTH, Desmond On 30 September 2015 at 10:21, Kurt Wendt <[email protected]> wrote: > Honestly - I don't remember if the old FPDos has the Copy To command > with the Excel output option. I suspect it may. Otherwise, you could > simply export data as a CSV - even just programmatically - and name > the file as Dummy.csv - and it should easily be able to load up in Excel! > > -K- > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > John J. Mihaljevic > Sent: Wednesday, September 30, 2015 11:09 AM > To: [email protected] > Subject: Exporting FPD DOS 2.6 reports to Excel > > Hi all, > > > > 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? > > Thanks, > > > > John > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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/80838f1ca795b14ea1af48659f35166f241...@drexch02.corp.globetax.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.
