Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  Export Excel Data into MySQL  /  Column Options

11.1 Column Options

The Column Options area is located below the preview grid. When you click each column header of the preview grid, you see the option values for the selected column. Some values are set by default: Column Name, Data Type, and so on. If a column option does not apply to the selected column or if the value cannot be changed, the option appears dimmed.

Use Advanced Options to modify the default behavior of the options that apply to all columns intended for export to a MySQL table.

MySQL for Excel analyzes and detects the data type of each column by default; however, you can override the detected value by selecting a different data type from the drop-down list. To reset a column back to the detected value, right-click within the Data Type field and select Reset to auto-detect, as shown in the figure that follows.

Figure 11.2 Reset a Data Type

Reset to auto-detect


User Comments
Sign Up Login You must be logged in to post a comment.