• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Controlling a Database from ... > Using DAO Recordsets to Move Data fr...

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 well when you want to remove records, or an easily identifiable group of records, from a table. Update queries are a good choice when you want to take the same action on some or all the records in a table. But when you need your code to examine each record individually and perhaps take action conditionally, you probably need to use a recordset.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint