I’ve been asked for help in automating a reporting process for another team within my company, when I got walked through the process, I first noticed that their whole reporting process data was stored and managed in MS Access, their queries were done in Macros and finally exported into excel files.

I mostly use Python / Power Automate Desktop to automate reports and other processes but I find MS Access pretty difficult to maintain in the future (also this MS Access DB was locally stored and maintained by one person). I’m looking for advice to whether proceed to automate Access, UI elements and refreshing their excel reports, or Migrating to SQL Server (or any other Database Management System) and be able replace macros with SQL code and finally automating their process in an easier way while maintaining longevity.

I did some research, there is a SQL Server Wizard that migrates MS Access Databases into SQL Server Databases, maintaining queries, tables, etc.

I’m not sure whether this is the best option or not or if anybody has been in this kind of situation.