Use the Excel file as an ODBC data source (connection string info here), and your MySQL database as the destination (using their ODBC connector). What OS is your process running on?

NDR PBS Line List import into local Database This module reads an excel file (NDR PBS Line List) into a pandas data frame and push the data into a local MySQL database. The aim is to perform analysis ...

Contribute to PriyanshMaskhare/import_excel_In_mysql development by creating an account on GitHub.