Advanced options enable you to mange the way MySQL for Excel imports data from MySQL tables, views, or procedures. Use
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.
The following figure shows the general options that apply to import-data operations.
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.
The following figure shows the formatting options that apply to import-data operations.
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
]
The following figure shows the Excel table options that apply to import-data operations.
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.