| 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 termed stored procedures in SQL Server.) The final chapter in this book, "Controlling a Database from Excel Using ADO and DAO," focuses on moving data the direction opposite to that discussed in this chapter. It does so by making use of action queries, DAO, and the ADO Command object. | 