Add a spreadsheet to a data access page

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

You can add a spreadsheet control 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 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, display the toolbox.

2. Click the Office Spreadsheet tool in the toolbox.

3. Click on the data access page where you want the upper-left corner of the control to be.

4. Enter data and formulas or import data to use in the spreadsheet.

5. Use the toolbar in the spreadsheet and the Spreadsheet Property Toolbox to complete the spreadsheet and make it look and behave the way you want.