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)

PowerQuery is a great Excel feature which allows users to discover, combine and refine data across a wide variety of sources.
Access allows users to connect to a wide array of external data sources in a way that is unique to Access users and scenarios.
When we think of data management solutions across Office, we think of Excel and Access as somewhat complementary products, but not competing.
With that, duplicating capabilities from one product to another is not supportive of this perspective.
We are looking at further enhancing and improving Access’s abilities to connect to external data sources, but not in the form of integrating PowerQuery.
55 comments
-
Carl commented
Great idea
-
Bauer commented
I need it. Great idea
-
Lizzz commented
what a great and important idea!
-
Anonymous commented
Best thing you can do.
-
John Peters commented
We need this function!
-
Bettina commented
Would be an awesome feature
-
Anonymous commented
Absolutely a MUST!
-
KBeu commented
Would be a very appreciated enhancement of the best RAD tool on the market :-)
-
Mike commented
Very goog idea. I hope, it will be integrated!
-
Anonymous commented
An easy way to combine the possibilities of PowerQuery and a database would be awesome!
-
Walter commented
Power Query should be integrated in Access!
-
Foetrade commented
Yes, power query in Access
-
orange commented
I would like see power query or an equivalent added to Access.
-
ridders commented
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
See also the thread https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/18917560-give-us-a-new-dll-msjson-dll
-
Anonymous commented
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!