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