Microsoft Office Tutorials and References
In Depth Information
Chapter 24
Excel Query Program
Connecting to a Database . . . . . . . . . . 501
Executing a Database Query . . . . . . . . . 508
Editing a Query . . . . . . . . . . . . . . . . . . . 505
Using the Excel Query Program . . . . . . . 515
The Excel Query program developed for this topic is a practical application of many of the
tools and techniques that you learned elsewhere in this topic. The program can easily be
packaged as an add-in or work as a stand-alone workbook template, plus it combines various
forms and toolbar elements into a cohesive program.
Excel Query Program Overview
The Excel Query program is implemented as an add-in to Microsoft Excel. This add-in lets
you perform database queries and return the results as part of a worksheet. The interface to
the program is through a new command bar, named Excel2k3 VBA Query , and it has four
main components: a drop-down list containing the queries that have been executed, a button
to edit a query, a button to run the query, and a button to configure the database connection.
(See Figure 24-1.)
Figure 24-1.
The user interface to the query program is through a new command bar added
to Excel.
Search JabSto ::




Custom Search