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 ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
