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

Article translations Article translations
Article ID: 281640 - View products that this article applies to.
This article was previously published under Q281640
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page


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


  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.


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


Article ID: 281640 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft FrontPage 2000 Standard Edition
kbnosurvey kbarchive kbhowto kbhowtomaster KB281640

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from