Home > Documentation > MS Excel to MySQL > Tutorial

Step 1 of 5. Select Conversion Scenario

On this step user should specify how to convert MS Excel spreadsheet into MySQL database. Excel to MySQL convertrer provides two options of database migration:
  • Move to MySQL server directly - the converter migrates MS Excel data to MySQL server directly. It requires live instance of MySQL server and sufficient permissions to write into a database on the target server. See Connect to MySQL Server section for related information.
  • Store into dump file - exports the contents of MS Excel spreadsheet into a local SQL script file. The resulting file contains MySQL data definition statements to create tables and 'INSERT' statements to fill tables with the data. See Import MySQL dump files article for related information.

Have questions? Contact us