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? If Windows ...

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.

In the Connection Properties window, click the "Definition" tab. Locate the text in the Command Text box. The native SQL query code appears there. ... How to Create Excel Spreadsheets With MySQL.