Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  Import MySQL Data into Excel

Chapter 9 Import MySQL Data into Excel

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

To import MySQL data into an Excel worksheet

  1. Start Excel, select the Data menu tab, and then click MySQL for Excel to open the MySQL for Excel task pane.

  2. From the Open a MySQL Connection area in the task pane, double-click an existing local or remote connection to display the available database schemas.

  3. Select a schema from the list and click Next to display all database objects in the schema (tables, views, and procedures).

  4. Select the table, view, or procedure with data to import and then click Import MySQL Data. A preview window displays the selected data and provides Options and Advanced Options to be used during the import operation.

    For a description of each import option, see Section 9.2, “Importing a Table or View” or Section 9.3, “Importing a Procedure”.

    For a description of each advanced option, see Section 9.4, “Import — Advanced Options”.

  5. Click Import to finish the operation.

Importing a table displays a dialog that is similar to the following figure.

Figure 9.1 Importing table data with MySQL for Excel

Content is described in the surrounding text.

User Comments
Sign Up Login You must be logged in to post a comment.