Managing Data with Microsoft® Excel

Using DAO Recordsets to Move Data from Excel to a Jet Database

As yet, this book has touched only very lightly on the topic of using recordsets to store data in a database. There are more efficient methods, discussed in the prior sections of this chapter as well as in earlier chapters. When you can use a Select query to return fields and records from a database, by all means do so. When you can use an existing action query, or create one temporarily, to modify records and fields, that's usually the method to use. SQL-based queries make more efficient use of your system's resources than do recordsets.

Append queries are fine when you want to add a group of records to a database table without a lot of intermediate processing. Delete queries work ...