From:       To:      
Home > Documentation > MS Access to MySQL

Edit Tables in MS Access to MySQL Converter

[MS Access to MySQL Converter]  [Introduction to Migration]  [Tutorial]

This feature allows to modify table name and customize types mapping. MS Access to MySQL converter maps types into the most appropriate MySQL equivalents. However, sometimes it is necessary to change type for one or multiple columns or exclude certain columns from conversion results.

To customize migration of certain MS Access table to MySQL, double-click on the appropriate item in listview on the left of "Select Tables" wizard page. Then dialog box appears that allows to specify table name, type and default value for every field using "Field info" group of controls. Also it is possible to exclude columns from conversion result by unchecking the corresponding checkbox.

Note: listview on the left of "Edit Table" dialog window contains column attributes for the original Microsoft Access database, new custom types and attributes will be displayed in "Field info" controls when the corresponding item is highlighted in the listview.

Inaccurate modification of table structure may break the database integrity (for example, loosing indexes or foreign keys). Users should be very careful with "Edit Table" feature.