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.
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
Mouse click to
toggle the selection of individual columns, or
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
All option, depending on the current status.
The dialog while importing a table includes the following options:
Include Column Names as Headers: Enabled by default, this inserts the column names at the top of the Microsoft Excel spreadsheet as a "headers" row.
Limit to ___ Rows and Start with Row ___:
Disabled by default, this limits the range of imported data.
Limit to option defaults to
1, and defines the number of rows to
Start with Row option defaults
1 (the first row), and defines where the
import begins. Each option has a maximum value of COUNT(rows)
in the table.
Importing a table displays a dialog similar to the following:
Importing a view or procedure displays a similar dialogue, but with the following options:
Include Column Names as Headers: Enabled by default, this will insert the column names at the top of the Excel spreadsheet as a "headers" row.
Import: Because a procedure might return multiple result sets, the import options include:
Selected Result Set: Imports the selected tab sheet. This is the default behavior.
All Result Sets - Arranged Horizontally: Imports all result sets into the Excel Worksheet horizontally, and inserts one empty column between each result set.
All Result Sets - Arranged Vertically: Imports all result sets into the Excel Worksheet vertically, and inserts one empty row between each result set.
For example, a dialogue like the following is displayed after importing a procedure and pressing the Call button to invoke the stored procedure: