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 DaveC@flexipol.co.uk wrote:
Darren, Good spotting!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@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-bounces@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, 1 March 2016 2:07 AM To: profoxtech@leafe.com Subject: Re: Import/Export with CSV
On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche tedroche@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]