Date Added: Feb 2006
There are numerous situations when VBA is not only the preferred way to obtain data, but the only way. This chapter excerpt from Integrating Excel and Access explains when VBA is required and how to incorporate it into Microsoft Excel and Access.
Extracting data and moving it between Microsoft Excel and Access can usually be accomplished in several different ways. However, there are situations where Visual Basic for Applications (VBA) is not only the best way to retrieve data, it is the only way. This downloadable chapter excerpt from Integrating Excel and Access, by Michael Schmalz explains when to use VBA and how to properly code and manipulate the queries.
Title: Integrating Excel and Access
Author: By Michael Schmalz
Publisher: O'Reilly Media, Inc.
Chapter 3: Data Access from Excel VBA
ISBN: 0-596-00973-9; First Edition November 2005; Copyright 2005
Previously published book chapters on TechRepublic can be found using the book chapter tag.