From:       To:      

Home > Documentation > MS Excel to MySQL > FAQ

Edit Table

You can change column name/type or rename table in the resulting MySQL database using table structure customization. This feature can be accessed by double-clicking on the corresponding table name in "Selected tables" list of "Step 4 of 5" wizard page.

This will cause the following dialog box to appear:

To customize type mapping select the appropriate item in the listview on the left and specify new name, type and default value for the field using "Field info" group of controls. Please note that listview on the left contains column attributes of the original types mapping, new custom types and attributes will be displayed in "Field info" controls when the corresponding item is highlighted in the listview.

Have more questions? Contact us