Executing MS Access Macro (functions/ queries/ forms) via Python

Recently we got a task to help other teams take over couple of tools, forms and reports. One of tool is MS Access based form that pulls sales data via ODBC and store it in the Access DB itself. Since there is a limitation of size per Access DB file, we plan to move the SQL query part from Access to Teradata and Access only handle the Form/Macro/VBA parts.

We won’t cover SQL migration in this session while we will focus on how to use Python drive Teradata query through Macro and execute the Macro stored in Access DB.