Add PowerQuery to ACCESS
PowerQuery is the best improvement for collecting data for Excel since many years. I would love to use it in Access too, without using Excel.
I would like to extract data from SAP, WEB, CSV-Files, collect all files from a folder, de-pivot files... Any ETL job PowerQuery supplies für Excel, but directly in Access!
(I posted this two years ago using other words)
John Peters commented
We need this function!
Would be an awesome feature
Absolutely a MUST!
Would be a very appreciated enhancement of the best RAD tool on the market :-)
Very goog idea. I hope, it will be integrated!
An easy way to combine the possibilities of PowerQuery and a database would be awesome!
Power Query should be integrated in Access!
Yes, power query in Access
I would like see power query or an equivalent added to Access.
Definitely - I currently use Excel PowerQuery (or Get & Transform in Excel 2016) to import & parse JSON files as this is currently impossible in Access)
The features provided by the PowerQuery add-in are excellent & Access needs the same functionality
Its about time Access received some of the Power and Database type tools that Excel seems to get by default. Please share the "Love" Microsoft as Access is not about to go away any time soon!