Looking Ahead
This chapter has focused on bringing data into the workbook using recordsets. You've seen how to use the CopyFromRecordset method to acquire data en masse, and you have seen how to use queries and parameters to define recordsets that can be managed record-by-record.
The queries discussed in this chapter are select queries. Their sole purpose is to extract records and fields from tables, and to make the records and fields available to you for editing via recordsets. A select query makes no change to the underlying data, nor to the tables that contain the data.
There is another large class of queries, termed action queries. These queries do act on the data, by inserting or deleting records, or by modifying them. (Action queries are ...
Get Managing Data with Microsoft® Excel 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.
