Summary
In this chapter, we 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 some data collections from MySQL that will run when a workbook is opened.
We learned about the advantages of creating generic data readers that can run various SQL statements and return results for use in Excel. We imported data for editing or adding records and wrote the changes back to MySQL. We exported Excel data to MySQL as a new table and created pivot tables with attached charts.
The purpose of including Chapter 9 and Chapter 10 was to introduce you to several methods of using MySQL with Excel by using DSN connections, VBA, and MySQL for...
