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 a list of database objects (tables, views, and procedures).
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 advanced option, see Figure 5.2, “Importing table data with MySQL for Excel: Advanced options”.
Clickto finish the operation.