Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  Import MySQL Data into Excel  /  Importing a Procedure

9.1 Importing a Procedure

To import a stored routine (procedure), first select the appropriate routine parameters, if needed, and then click Call. Next, use the following options to configure the import operation:

  • Include Column Names as Headers: Selected by default, this will insert the column names at the top of the Excel worksheet 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 preview area within the Import Data window, similar to the one shown in the following figure, will display after you select routine parameters and then click Call to execute the routine.

Figure 9.2 Importing called stored procedure data with MySQL for Excel

Content is described in the surrounding text.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.