9.2 Import — Advanced Options

Advanced options enable you to mange the way MySQL for Excel imports data from MySQL tables, views, or procedures. Use Reset to Defaults to restore the original option selections and values.

A set of advanced options affect the current import-data operation, as described in the sections that follow.

• General Tab

• Formatting Tab

• Excel Table Tab

General Tab

The following figure shows the general options that apply to import-data operations.

Figure 9.3 Importing table data with MySQL for Excel: General Options

General Options:

• Use the first [10] rows to preview the MySQL table's data. This option affects the preview step in the import process and defaults to 10.

• Escape text values that start with "=" so Excel does not treat them as formulas. This option may not reflect any differences in the preview because it is only applied after the data is imported into the Excel worksheet.

Formatting Tab

The following figure shows the formatting options that apply to import-data operations.

Figure 9.4 Importing table data with MySQL for Excel: Formatting Options

Formatting Options:

• Excel number format for DateTime and TimeStamp data: [m/d/yyyy h:mm]

• Excel number format for Date data: [m/d/yyyy]

• Excel number format for Time data: [hh:mm:ss]

Excel Table Tab

The following figure shows the Excel table options that apply to import-data operations.

Figure 9.5 Importing table data with MySQL for Excel: Excel Tables Options

Excel Table Options

• Create an Excel table for the imported MySQL table data. Selected by default and has the following settings:

  • Use style [ ] for the new Excel table. Defaults to MySqlDefault.

  • Prefix Excel tables with the following text: _______. Deselected by default.