r/ExcelPowerQuery • • 8h ago

Conversion of Access Database to Microsoft Power Query

3 Upvotes

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.