Export a datasheet to static HTML format
- 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.
- In the Save As Type box, click HTML Documents (*.html;*.htm).
- 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.
- In the File Name box, enter the file name.
- Select the Save Formatted check box to: save the table, query, or form in a format similar to its appearance in Datasheet view, enable the AutoStart check box, and display the HTML Output Options dialog box after you click Save in step 6.
- Select AutoStart if you want to display the results in your default Web browser.
- Click Save.
- If you selected Save Formatted in step 5, the HTML Output Options dialog box is displayed. In the HTML Template box, you can enter the location of an HTML template. Learn about HTML Template files.
Once you have output a datasheet to an HTML file, you need to publish it to make it available on the World Wide Web. Learn about publishing static HTML files to a Web server.
Notes
- If the datasheet contains a parameter query, Microsoft Access first prompts you for the parameter values, then exports the results.
- Fields with a Hyperlink data type are output as hyperlink addresses by using <A HREF> HTML tags.
- If you selected Save Formatted in step 5, the HTML table simulates the appearance (including color, font, and alignment) of the datasheet.
- Although a default theme is not applied when you export the datasheet, you can apply a theme by creating a data access page from an existing Web page (in this case, the static HTML file you just created), applying a theme in page Design view, and then saving the page. Learn about using themes.
- 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.