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. ...
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.
