O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® by John Green, Rob Bovey, Stephen Bullen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required