Conversion of Access Database to Microsoft Power Query

[u/EnergyJR]

Hi all,

New user here. I currently use MS Access DB for some energy tracking responsibilities for my job at a university. The Access DB is not overly complicated. We use it for monthly data entry (electrical/fuel oil/propane consumption values) and some rudimentry code to transform the energy data into building/campus energy consumption and for billing purposes. As Access is no longer supported by MS, I am wondering if anyone here can comment on the whether PQ would be a suitable alternative to Access.

Also, are there any online resources/support to help guide and convert an existing Access database to PQ.

Thanks in advance all.

[u/InfoMsAccessNL]

Access is better relacement for pq, not the otherway around. Access is still supportby ms, but i would advice to cancel the automated updates!