Export a datasheet to server-generated HTML format

1. In the Database window, click the name of the table, query, or form, you want to export, and then on the File menu, click Export.
   
   
2. In the Save As Type box, click Microsoft IIS 1-2 (*.htx;*.idc) or Microsoft Active Server Pages (*.asp) depending on which server-generated HTML output format you want. Learn about server-generated HTML.
   
   
3. Click a shortcut on the Places Bar or click the arrow to the right of the Save In box and select the drive or folder to export to.
   
   
4. In the File Name box, enter the file name.
   
   
5. Click Save.
   
   
6. Enter the appropriate information in the Microsoft Active Server Pages Output Options or HTX/IDC Output Options dialog boxes:

   In the HTML Template box, enter the location of an HTML template. Learn about an HTML Template file.

   In the Data Source Name box, enter the name of the ODBC data source that you will connect to when the server-generated HTML files are processed on the Web server. Learn about ODBC data sources.

   For a Microsoft Access database, in the User to Connect As and Password for User boxes, enter a user-level security username and password to allow users access to the Access database from the Web page. If you do not enter a username or password, the default username is Admin, and no password is used. Learn about user-level security.

   For a Microsoft Access project, in the Username and Password boxes, enter a database username and password to allow users to access the Microsoft SQL Server database from the Web page. If you do not enter a username or password, the default username is Sa and no password is used. Learn about SQL Server database security.

Once you have output a datasheet to ASP or IDC/HTX output format, you need to publish the files to make them available on the World Wide Web. Learn about publishing server-generated HTML files to a Web server.

Notes  

• If the datasheet contains a parameter query, Microsoft Access simulates the Enter Parameter Value dialog box by creating an additional HTML parameter page that contains an HTML form text box control for entering the parameter value, and a button for running the query. You must explicitly define the parameter data types when you create the parameter query. You must also display this HTML parameter Web page before you display the datasheet Web page. During the export operation, Microsoft Access executes the query and displays the Enter Parameter Value dialog box, but you can just click OK because the input is ignored.
  
  
• Fields with a Hyperlink data type are output as strings using the following hyperlink address format: displaytext#address#subaddress#screentip. Although you cannot click the string in a Web browser to follow the hyperlink address, you can copy and paste the address portion into the Address Bar of the Web browser.
  
  
• A datasheet with many records may take a long time to output and display through a Web browser. Consider reducing the size of the datasheet by using criteria such as a date field or by using a parameter query.