Microsoft KB Archive/281640

Knowledge Base

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

Article ID: 281640

Article Last Modified on 10/27/2002

---

APPLIES TO

• Microsoft FrontPage 2000 Standard Edition

---

This article was previously published under Q281640

IN THIS TASK

SUMMARY

• Procedure

REFERENCES

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

REFERENCES

For additional information about Office Web Components, click the article numbers below to view the articles in the Microsoft Knowledge Base:

231419 OFF2000: How to Deploy the Web Components Over an Intranet

253338 INFO: Office Developer Samples and Tools Available for Download

back to the top

Additional query words: front page

Keywords: kbhowto kbhowtomaster KB281640

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.