Share this Page URL

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

Integration with Office 2003 and SharePoint Services 554 Bringing Access Data into Excel By now, you should be seeing a certain consistency in the way Microsoft products interact with data. That's intentional. The original vision for Microsoft Office (and Windows products too) is that there would be a strongly compatible data architecture that supported the entire product line and that would show up in a consistent user interface and procedural model. Over time, this model is coming to fruition. Excel works with Access in much the same way as InfoPath and SharePoint. Because of this, sharing data (which encompasses the first set of capabilities we'll be looking at) works sim- ilarly to the way it did in the other products. Their common design architecture makes sharing data between Access and Excel a snap. Let's first explore how we can bring data from Access into Excel and manipulate it so that we can learn something new about that data. Excel can import data stat- ically or dynamically-we'll look at each in turn. Before beginning this exercise, make sure that the Northwind database isn't open in Access; if it is, you might encounter a file access restriction. Import data into Excel from Access 1. 2. 3. Open a new spreadsheet in Excel 2003. On the Data menu, click Import External Data, Import Data. In the Select Data Source dialog box, open the Northwind database. A Select Table dialog box appears, as shown here. In this dialog box, you can select the table you want to display in Excel.