27.3 Import MySQL Data into Excel

Data can be imported from MySQL into a Microsoft Excel spreadsheet by using the Import MySQL Data option after selecting either a table, view, or procedure to import.

Choosing columns to import

By default, all columns are selected and will be imported. Specific columns may be selected (or unselected) using the standard Microsoft Windows method of either Control + Mouse click to toggle the selection of individual columns, or Shift + Mouse click to select a range of columns.

The background color of a column shows the status of each column. The color white means that the column has been selected, and therefore it will be imported. Conversely, a gray background means that the column will not be imported.

Right-clicking anywhere in the preview grid opens a context-menu with either a Select None or Select All option, depending on the current status.

Importing a table

The dialog while importing a table includes the following options:

The Advanced Options include:

Figure 27.4 Importing table data with MySQL for Excel: Advanced options

Importing table data with MySQL for Excel: Advanced options

General Options:

Excel Table Options:

Importing a table displays a dialog similar to the following:

Figure 27.5 Importing table data with MySQL for Excel

Importing table data with MySQL for Excel

Importing a view or procedure

Importing a view or procedure displays a similar dialogue, but with the following options:

For example, a dialogue like the following is displayed after importing a procedure and pressing the Call button to invoke the stored procedure:

Figure 27.6 Importing called stored procedure data with MySQL for Excel

Importing called stored procedure data with MySQL for Excel