Chapter 13. Programming with Databases

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.