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.
Pit Berthold commented
very good idea, really necessary!!
Uwe Tempelmeier commented
The direct way is the best. Today one needs to include a workaround using Excel.
Bernd H. B. commented
The best of two worlds can work together. Really necessary in ACCESS.
Alexander Cimen commented
really necessary, great idea
Es una muy buena idea!!!
makes life easier
Georg bauer commented
Walter Hackl commented
Yeah, pls add it to Access!
I need it. Great idea
what a great and important idea!
Best thing you can do.
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!