Feedback by UserVoice

I suggest you ...

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)

645 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Peter Rühm shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    No Current Plan  ·  AdminAccess Team (Admin, 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.

    52 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base