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)

189 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Peter RühmPeter Rühm shared this idea  ·   ·  Admin →

    8 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • KBeuKBeu commented  · 

        Would be a very appreciated enhancement of the best RAD tool on the market :-)

      • MikeMike 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!

      • WalterWalter commented  · 

        Power Query should be integrated in Access!

      • FoetradeFoetrade commented  · 

        Yes, power query in Access

      • orangeorange commented  · 

        I would like see power query or an equivalent added to Access.

      • 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!

      Feedback and Knowledge Base