Power Query is an add in for Excel 2010 and 2013. We are going to implement it in our newer BI model later this year.
Is it useful for VFP data? I don't think so. We are consider it for repeat queries that could mimic a union clause in a query. Our ERP had separate tables for Order Headers depending on the business company data you are looking for. We have 5 different companies operating within our system depending on the type of business and the location it is. All of that considered I don't think that Power Query will be any assistance to making a CSV output. On Tue, Mar 1, 2016 at 2:24 AM, Dave Crozier <da...@flexipol.co.uk> wrote: > Darren, > Good spotting! > > Dave > > -----Original Message----- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren > Sent: 29 February 2016 21:22 > To: profox@leafe.com > Subject: RE: Import/Export with CSV > > Took a look at that link and it references an Excel add-on - "Power Query" > - looks like a great additional to Excel. As a bonus seems to sort out the > issue raised. > > > > > http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha > -numerical-in-an-exported-csv-file-opened-in-exc?rq=1 > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted > Roche > Sent: Tuesday, 1 March 2016 2:07 AM > To: profoxt...@leafe.com > Subject: Re: Import/Export with CSV > > On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche <tedro...@gmail.com> wrote: > > > > Alternatively, there may be some option in the Excel import dialog to > > turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice > > user, sorry.) > > See Also: > > http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha > -numerical-in-an-exported-csv-file-opened-in-exc?rq=1 > > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/CAJidMYKMFdvKYbERHW7Su5OfFes6EuD7J7ytkqhdmosa=js...@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.
