Table of Contents [+/-]
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
Start Excel, select themenu tab, and then click to open the MySQL for Excel task pane.
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.
Select a schema from the list and clickto display all database objects in the schema (tables, views, and procedures).
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 advanced option, see Figure 9.2, “Importing table data with MySQL for Excel: Advanced options”.
Clickto finish the operation.