Home > Documentation >
MS Excel to MySQL > Tutorial
Step 4 of 5. Conversion Settings
On this wizard screen you can customize the conversion process using
the following settings:
- MySQL character set - tune this parameter to set up
correct encoding of text values in the database. Please refer to
to better understand the concept of character sets and collations.
- MySQL engine type - storage engine determines basic characteristics
of handling tables such as storage limits, transaction-safe, locking granularity, etc.
Each of them has its own cons and pros. Please refer to
for the further information.
When converting from MS Excel spreadsheet (*.xls) file you can also specify
two conversion settings on this page:
- Extract MySQL field names from the first row - select this
checkbox to extract MySQL field names from the first row of each worksheet.
Otherwise, Excel-to-MySQL generates field names as
F<field number> (e.g. F1, F2, F32, etc).
- Refine type conversion - select this checkbox to allow
the program to improve type mapping during the conversion process. See
Intelligent types mapping article
for related information.
- Skip empty rows - select this checkbox to not convert
MS Excel rows containing empty cells only.
Have questions? Contact us