O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

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 18. Introduction to Database Development

A large percentage of non-trivial Excel applications require some sort of external data store, usually in the form of a database. In this chapter we cover the basics of database design, SQL syntax, and the ADO object model. We do not go into great detail on any of these topics, as all of them are book-length subjects in their own right. By the end of this chapter, however, you will have all the fundamental tools required to begin incorporating a database into your application. In the next chapter we demonstrate how to apply these tools to Microsoft Access and SQL Server development.

An Introduction to Databases

Working with databases is significantly different from working with Excel worksheet tables. ...

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