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:
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. The
Limit tooption defaults to1, and defines the number of rows to import. TheStart with Rowoption defaults to1(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
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:
: Imports the selected tab sheet. This is the default behavior.
: Imports all result sets into the Excel Worksheet horizontally, and inserts one empty column between each result set.
: 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 button to invoke the stored procedure:
