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

This article was previously published under Q281640
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to use the FrontPage 2000 Database Results feature to populate the Office 2000 Spreadsheet Component.

back to the top


  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

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

front page

Article ID: 281640 - Last Review: 10/26/2013 16:38:00 - Revision: 2.0

Microsoft FrontPage 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbhowtomaster KB281640