Show All

Add a spreadsheet to a data access page

You can add a Microsoft Office Spreadsheet Component to a data access page to provide some of the same capabilities you have in a Microsoft Excel worksheet. You can enter values, add formulas, apply filters, and so on. Use the procedure below to create a spreadsheet in which you enter raw data, or into which you import data from a Web page or text file. If within the spreadsheet you want to use data from other controls on the data access page, you need to refer to those controls in the appropriate spreadsheet cells.

1. In Design view of a data access page, click Toolbox on the toolbar.
2. In the toolbox, click the Office Spreadsheet tool .
3. Click the data access page where you want the upper-left corner of the control to be.
4. Click inside the control to activate the spreadsheet.
5. Right-click inside the control, and then click Commands and Options.
6. Using the Commands and Options dialog box, customize the appearance and behavior of the spreadsheet.

For more help on designing and using a spreadsheet, click Help on the spreadsheet toolbar. If the toolbar is not visible, select the Toolbar check box on the Workbook tab of the Commands and Options dialog box.