Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt
PDF (US Ltr) - 2.6Mb
PDF (A4) - 2.6Mb
EPUB - 2.2Mb
HTML Download (TGZ) - 2.2Mb
HTML Download (Zip) - 2.2Mb


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 Figure 9.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.