Chapter 12: Working With Microsoft Excel VBA – Part 2

To set up and properly demonstrate using 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 Developers tab and the VBA IDE so that you can develop in VBA. We will then connect to a 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'll know how to use MySQL for Excel to load, modify, and update MySQL records directly in the database. You'll finish off by learning how to push worksheets from Excel into a new MySQL table.

This chapter covers the following concepts:

• An introduction to MySQL connections
• Connecting to the MySQL database using...