Question: how to transfer excel data to mysql database?
Answer: Start Excel, select the Data menu tab, and then click MySQL for Excel to open the MySQL for Excel task pane.
From the Open a MySQL Connection area in the task pane, double-click an existing local or remote connection to display the available database schemas.