Many years ago you could concentrate on understanding Excel, and that would have been enough to get by. Today, however, it is becoming increasingly difficult to avoid coordinating your Excel activities with a back-end data source of some kind. This chapter provided you with a solid introduction to using SQL and ADO to access various data sources. Due to space constraints, this chapter could only scratch the surface of possibilities in each section. So if data access is or might become a significant part of your development effort, you are strongly recommended to obtain and read more specialized books on the subject.
The next chapter continues to look at managing external data with Excel by examining some of the built-in features provided by Excel for this purpose.
Was this article helpful?