You can start here: https://python-forum.io/Thread-SqlAlchem...-Data-Load
This tutorial covers most everything that you have as your requirements, albeit the data comes from a website, and the database is SQLite. When using SQLAlchemy, the only changes required to switch from one DBMS to another, is a single line to specify the DBMS, and any name changes required for data-types (which should be minimal if any at all).
And of course, the model will have to be written for you tables.
This tutorial covers most everything that you have as your requirements, albeit the data comes from a website, and the database is SQLite. When using SQLAlchemy, the only changes required to switch from one DBMS to another, is a single line to specify the DBMS, and any name changes required for data-types (which should be minimal if any at all).
And of course, the model will have to be written for you tables.