Using Power Query to Extract a Query from Access

[LtCmdrData]

Hello, I am new to Power Query so bare with me. I have a query in MS Access that pulls data from two different tables. I would like to use Power Query (using a dynamic parameter) to extract the data from Access into Excel where I can further manipulate it. Is this something Power Query is built for or am I trying to use it the wrong way? Would I be better off trying to write a VBA macro to accomplish the same thing? I would appreciate any guidance available on this project. The ultimate goal is to speed up and streamline an entire process for a co-worker. Thanks.

 

[VBA Geek]

You can build a parameter table: https://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/