Share this Page URL

Chapter 15. Integration with Office 2003... > Analyzing Access Data Through Excel - Pg. 556

Integration with Office 2003 and SharePoint Services 2. 556 On the Data menu, click Import External Data, New Database Query. The Choose Data Source dialog box appears. Understanding how Excel connects to external data sources When it comes to connecting to external data, there are a number of ways to bring data into Excel, and there are a number of different data sources Excel can use in addition to Access data. We can't cover all the different types here. Keep in mind, however, that Excel links to Access data in the same way that it links to other types of data, so it will be important to understand the architecture Excel uses. Instead of linking to Access directly, Excel creates a sort of abstraction layer, a layer of program code that abstracts the different data sources into a kind of universal language that Excel reads. Specifically, Excel uses queries to connect to data from other data stores by using Microsoft Query to create a query-based data connection. As you've learned, a query is a type of program that links tables and fields and selects data based on a criterion or set of criteria. As long as the program that reads the query understands the language in which the query is written, it doesn't really matter what data source the query uses. Excel takes advantage of this and links to Access tables (as well as other data sources) by way of this mech- anism. 3. In this dialog box, you can connect to various data sources. We want to view Access data, so make sure the Databases tab is selected, and select MS Access Database in the list, as shown here. Make sure the Use The Query Wizard To Create/Edit Queries check box is selected, and click OK.