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.
Also, you can choose data source:
- MS Excel spreadsheet - export data from MS Excel spreadsheet (*.xls) file
- CSV file - export data from comma-separated values file. See CSV Files article for related information.
Have questions? Contact us