Databases Reference
In-Depth Information
FIGURE 7.10
Adding the XLODBC.XLA Reference.
that a Folder named References appears in the Project Explorer that contains “Reference to
XLODBC.XLA.”
The XLODBC.XLA Reference makes a wide range of functions available for use in ODBC
connectivity to databases using Excel VBA. The available functions and the action they each perform
are listed in Table 7.4.
The XLODBC Reference is important because it allows Excel VBA programmers to access
information in Microsoft Access using its predefined functions with relative ease. When extracting
information from an Access database, the user should have the ability to gather information about
FIGURE 7.11
A properly installed XLODBC.XLA Reference.
