Excel to MySQL bridge
Excel - MySQL Bridge Hello! This post contains simple python code written by me to transfer all Excel file table data to MySQL database running on your local machine and vice-versa. How to do this? There are two scenarios 1. Transferring the Excel table to MySQL database 2. Transferring the MySQL table to the excel sheet. 1. Excel to MySQL: Prerequisites to do this are you need to have a CSV file of the data. (Comma Separated Values) Also, first row should contain the column names and data from the second row onward. Turn on the XAMPP or WAMPP server so that code can access your local server. Create a database by any name. In the code it's phpgang . Run the Python code. (You need to have Python installed in your computer, you can download it from official Python site) This will transfer all the data from you CSV file to the MySQL database. Note: This script considers String as a defaul...