Chapter 13. Programming with Databases

A large percentage of nontrivial Excel applications require some sort of data store that is separate from the rest of the application, usually in the form of a database. In this chapter we cover the basics of database design and data access using SQL and ADO. We do not go into great detail on any of these topics. All of them are book-length subjects in their own right. After some brief introductory material, we demonstrate these technologies by showing how to use them for their most common purposes. At the end of the chapter, we suggest additional books that you can use for in-depth study of the topics we introduce here.

An Introduction to Databases

The biggest problem for Excel-centric developers making the ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.