From Excel to Access and Back Again
This chapter is dedicated to dynamic actions on databases, meaning the algorithms run in Excel will actually change the content within the database. Two methods will be covered to perform dynamic actions upon databases within Excel VBA. The first method is to utilize SQL commands, and the second method is to utilize the DAO model. Both methods were introduced in Chapter 7.