This chapter examined the built-in features Excel provides for dealing with external data, as exposed through the QueryTable object. It showed how to use query tables to retrieve data from relational databases, web sites, and text files. The chapter examined how connection files allow you to persist QueryTable connection information to an easily modified and distributed text file, and you took a brief look at the two new objects used to manage connection information in Excel 2007: the Workbook .Connections collection and the WorkbookConnection object.

0 0

Post a comment