HOW TO: Use Database Results to Populate the Office Spreadsheet Component in FrontPage 2000 (281640)

SUMMARY

This article describes how to use the FrontPage 2000 Database Results feature to populate the Office 2000 Spreadsheet Component.

back to the top

Procedure

1. Open a Web on a Microsoft Internet Information Services Web server.
2. To create the database results page, follow these steps:
   1. Open a new page in FrontPage.
   2. On the Insert menu, click Database, and then click Results.
   3. Select the sample database connection, and then click Next.
   4. Under Record Source, click Customers in the list, and then click Next.
   5. Click Next to bypass any options.
   6. Select Table - one record per row, and then click Next.
   7. Select the Display all records together button, and then click Finish.
   8. Save the page as customers.asp to your Web, and then close the page.
3. To create the spreadsheet page, follow these steps:
   1. Open a new page in FrontPage.
   2. On the Insert menu, click Component, and then click Office Spreadsheet.
   3. Save the page as customers.htm to your Web.
   4. Click the Property Toolbox icon on the spreadsheet control.
   5. Expand the Import Data section of the Property toolbox.
   6. Type customers.asp in the URL box.
   7. Click the Import Now button.
   8. Select the Refresh from URL at run time check box.
   9. Close the Property toolbox.
   10. Save the page to your Web again, and then preview the page in Microsoft Internet Explorer.

When users browse the customers.htm page via HTTP using Internet Explorer, the Office Spreadsheet Component dynamically loads the data from the database.

back to the top