MySQL for Excel Guide  /  Import MySQL Data into Excel

Chapter 5 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 a list of database objects (tables, views, and procedures).

  4. Select the table, view, or procedure with data to import and then click Import MySQL Data. A preview windows 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 5.2, “Importing a Table or View” or Section 5.3, “Importing a Procedure”.

    For a description of each advanced option, see Figure 5.2, “Importing table data with MySQL for Excel: Advanced options”.

  5. Click Import to finish the operation.


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