Share this Page URL

Chapter 15. Integration with Office 2003... > Working with Outlook Data in Access - Pg. 559

Integration with Office 2003 and SharePoint Services 559 However, because you are in Excel, you can create cells with functions that perform calculations on the data in other cells. As you update data in your Access database, the calculation cells also will update and be reflected in the spreadsheet. This will allow you to perform immediate and pow- erful analysis of the data in your Access tables without having to create forms or write algorithms in code to do that work. The spreadsheet can then be published on your intranet to provide your colleagues with a quick yet powerful view into your data. This is just another way Microsoft Office along with Access can improve collaboration. Just the Steps Import data into Excel from Access 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. On the Data menu, click Import External Data, Import Data in a new Excel spreadsheet. Open a database, and select a table. Click OK. Click once in cell A1, and then click OK. Using Excel to sum data from an Access table Click the Sheet 2 tab in your Excel spreadsheet. Click in cell A1. In the formula bar (located just above the spreadsheet and just below the toolbar buttons), type =SUM(Sheet1!H2:Sheet1!H381). Click outside the formula bar, or press the Tab key. Create a dynamic link to data On the Data menu, click Import External Data, New Database Query in a new Excel spreadsheet. Make sure the Databases tab is selected, and select MS Access Database in the list. Make sure the Use The Query Wizard To Create/Edit Queries check box is selected, and click OK. Open a database. Select a table, and add it to the query list by clicking the > button. Click Next. Select a filter, and click Next.