I love PowerQuery for Excel for any ETL-jobs. Same tool for ACCESS?
For many ETL-Jobs in EXCEL I use PowerQuery. Many jobs, formely done with VBA, can now be solved codeless.
I would like to use the same techniques in ACCESS, e.g. collect many txt-files from one folder, unpivotize etc...
Greetings to the community!
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.
Sayth Anonymous commented
It would make far more sense going straight to Access, instead it's current path is, PowerQuery->Excel->Access->PowerPivot.