Share this Page URL

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

Integration with Office 2003 and SharePoint Services 558 9. The final wizard screen will populate the spreadsheet with data from the Access database. It will do so by creating a query and associating the query with the spreadsheet as the data source. What is distinctly different about the query approach as opposed to the import ap- proach is that in the former method, Excel maintains a relationship with the data source after the data is imported. This means that as data is updated or changed in Access, those updates and changes will be reflected in the spreadsheet. The Properties button in this screen allows