Activity 12.01 – building a MySQL-based Excel document

Note

The Excel document used in this project, CoffeeProducts.xlsx, can be found at https://github.com/PacktWorkshops/The-MySQL-Workshop/tree/master/Chapter12/Activity01.

You are working for a coffee shop, and currently, all the data for the shop products are stored in an Excel file. Your manager would like you to create a MySQL database that contains the Excel data, as well as setting up Excel connections so that they can continue to manage the data through Excel. Perform the following steps to implement this activity:

1. Create a new MySQL database named coffee_data.
2. Push the current data in CoffeeProducts.xlsx to the MySQL database.
3. Add a new product named Americano with a price of $3.50 and a size of medium.

   Note

   The solution for this activity can be found in the Appendix.

With this completed, you now have a fully functional Excel sheet that interacts with a MySQL database!