Looking Ahead
This chapter builds on a foundation begun in Chapter 7. That foundation puts you in a position to use VBA in conjunction with Excel to connect to external databases.
VBA and Excel can't connect to databases without help, though. You need to provide them with an object library, one that contains information about the objects, properties, and methods found in a database. ADO and DAO are two such object libraries, and this chapter has shown you how to integrate them with your VBA code, and how to open databases by applying references to the libraries.
You have also read about the theory and practice of making Access databases secure. This material was supplied because as data networks have become more and more accessible, shared databases ...
Get Managing Data with Microsoft® Excel 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.
