Feedback by UserVoice

I suggest you ...

← Access (Desktop Application)

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)

630 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Peter Rühm shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
No Current Plan  ·  AdminAccess Team (Product Manager, Microsoft) responded  · 

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

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
1 3 Next →

Access (Desktop Application)

Categories

Feedback and Knowledge Base

(thinking…)