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.

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?

Next, create a Hypertext Preprocessor (PHP) file to accept the data and insert it into the database. HTML is only capable of instructing a browser on the method of presenting information.

This PHP staple has been the most common MySQL management tool for over a decade. Migrating a database is as simple as selecting the database in the left column, clicking the Export link, and ...