Summary

In this chapter, you learned how to create a named DSN to the chinook database, add and use the DEVELOPER tab, and start the VBA IDE. We then created reusable functions to connect to MySQL using two different types of ODBC connections. We also learned how to read and import data from MySQL into a worksheet, define named ranges for the imported data, and assign the named ranges to charts using VBA. We set chart labels and categories using VBA and created and used drop-down lists to load filtered data, display data, and use it in charts. We then set data collections from MySQL that will run when a workbook is opened.

In Chapter 12, we will continue working with MySQL and Excel.