This repository contains the steps and codes applied to transfer data from Excel files to PostgreSQL database:
- Designing the database schema.
- Creating a PostgreSQL database, using SQL (DB_creating.sql).
- Reformulating data in Excel files to fit the database schema, using VBA (Excel_Transformation4.vb).
- Uploading the refomulated data from Excel files to Pandas dataframe, then populating the database with it, using Python (Excel_to_postgreSQL.py)
