Inserting data using MySQL for Excel

Using the connection that we have created, it is now possible to work with data between Excel and MySQL. One of the first things we will look at is how to get data from MySQL into an Excel workbook.

To be able to send data from MySQL to Excel, we will use the Import MySQL Data option in the MySQL for Excel plugin. This tool will allow us to move any relevant data we require from the database.

In the next exercise, we will see an example of inserting data.

Exercise 12.04 – inserting the top 25 selling artists

Your manager has asked you to include a list of the top 25 selling artists and their total sales in the dashboard. He wants to be able to see at a glance who the best-sellers are and feels that this will complete the dashboard.

In this exercise, we are going to include this list:

1. In the dashboard worksheet, click on the M15 cell to make it active. This will be the insert point of the data.
2. Double-click on the...