Managing External Data

Chapter 20 discussed how to access data with essentially unlimited flexibility using ADO. Excel also provides some built-in data management features, primarily through the QueryTable, ListObject, and WorkbookConnection objects. Excel's built-in data management features have less flexibility than custom ADO programming. For example, you can only use these features to retrieve data, not modify it. But they are simpler and offer a number of useful capabilities right out of the box. This chapter examines some of Excel's built-in data management capabilities.

0 0

Post a comment