Chapter 11: MS Excel VBA and MySQL – Part 1

Setting up and properly demonstrating the use of Excel with MySQL is quite involved, so the topic is split over two chapters. In this chapter, we will begin by setting up a sample MySQL database using a .sql script file and learn how to activate the Developer tab and the Visual Basic for Applications (VBA) integrated development environment (IDE) so that you can develop in VBA. We will then connect to the MySQL server and retrieve data using Excel VBA, create a dashboard with the data from MySQL, and populate drop-down lists and individual cells with VBA and MySQL data. By the end of the chapter, you will be able to create pivot tables and charts from MySQL data and you will have learned how to use MySQL for Excel to load, modify, and update MySQL records directly in the database, and we'll finish off by learning how to push worksheets from Excel into a new MySQL table.

This chapter consists of the following topics:

...