Microsoft KB Archive/268948

= HOW TO: Use an Excel Worksheet as a Data Source in FrontPage 2000 =

Article ID: 268948

Article Last Modified on 10/27/2002

-

APPLIES TO


 * Microsoft FrontPage 2000 Service Pack 1

-



This article was previously published under Q268948



IN THIS TASK
SUMMARY
 * Use an Excel Worksheet as a Data Source in FrontPage

REFERENCES



SUMMARY
This article describes how to use a Microsoft Excel worksheet as a data source in Microsoft FrontPage 2000.

back to the top

Use an Excel Worksheet as a Data Source in FrontPage
To use an Excel worksheet as a data source in FrontPage, follow these steps:  In Microsoft Excel, follow these steps:  Open the Excel worksheet, and select the data that you want to use. On the Insert menu, point to Name, and then click Define. Type a name for the selection, and then click OK. Quit Excel. If you are prompted to save changes you made to the worksheet, click Yes.  In FrontPage, open an existing web, or create a new web. On the File menu, click Import, and then click Add File.</li> Select the Excel worksheet that you modified in step 1. Click Open. Click OK.</li> On the File menu, point to New, and then click Page. Click Normal Page, and then click OK.</li> On the Insert menu, point to Database, and then click Results.</li> Click Use a new database connection, and then click Create.</li> Click Add. Give the database connection a name.</li> Click File or Folder in current Web, and then click Browse.</li> In the Files of Type list, select &quot;Microsoft Excel Driver&quot;, and then click Excel spreadsheet. Click OK two times.</li> Click Verify. Click Apply. Click OK.</li> Click Next. Accept the default settings until you reach the end of the wizard, and then click Finish.</li> On the File menu, click Save As. Save the file with an .asp extension.</li> Publish the web to a server that supports Active Server Pages.</li></ol>

NOTE: The same methods used to post to or query an Access database can also be used to post to or query an Excel worksheet.

back to the top

<div class="references_section">