Advanced options enable you to mange the way MySQL for Excel imports data from MySQL tables, views, or procedures. Useto 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.
Use the first [
10] rows to preview the MySQL table's data. This option affects the preview step in the import and edit processes and defaults to 10 rows. The value range is 1 to 100.
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.
Excel number format for DateTime and TimeStamp data: [
Excel number format for Date data: [
Excel number format for Time data: [
Import all floating-point data using a DECIMAL data type. This option imports floating-point data as type
DECIMAL, instead of
DOUBLE, to show the exact value of data stored the database. When this option is deselected, the floating-point values shown in the preview are approximate values. Selected by default.
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
Prefix Excel tables with the following text: _______. Deselected by default.