How to Export an MS Access Report to HTML


Microsoft Access offers several options of exporting report data into other file formats, including HyperText Markup Language (HTML). Reports exported to HTML can be easily incorporated into websites and formatted to meet your needs. Once exported, the HTML file includes all relevant data from your Access report, but the HTML format lets you customize the look and feel of the report.

Export Access Report to HTML

  • Open an existing report in Access or create a new report using the report wizard.

  • Select the records you wish to display in your report.

  • Select "Preview" mode from the "File" menu and review the report to ensure that it includes the appropriate data for your final file.

  • Select the tab from the header menu for "External Data."

  • Choose "More" under the "Export" area. Select "HTML Document."

  • Specify the name for the exported file and select the location to save the HTML file.

  • Choose the "Export data with formatting and layout" option in the next window if you have formatted your Access report and want to keep this layout in the HTML file. Select "Open the destination file after the export operation is complete" to view your resulting file once the export is complete. Select "Export only the selected records" if you selected a specific set of data in the Access report. This option will limit the results in your exported file to include only those selected in the report.

  • Select the option for "HTML Output Options" if you already have an HTML template that you want to use for your file layout. The wizard will prompt for the location of the HTML template.

  • Select the appropriate encoding type for your file. Default encoding is typically used, but Unicode and Unicode (UTF-8) are also available.

  • Save these steps so you can repeat them in the future without going through the wizard.

  • Open your file using your HTML editor or viewer to review the formatting. The data from your Access report will be included in the file and the format can be edited as needed.

Tips & Warnings

  • Depending on your version of Access, the location of the export tools may vary. You should be able to use the "File" menu to access the export tools no matter which version you are using.

Related Searches


  • Photo Credit Jupiterimages/Comstock/Getty Images
Promoted By Zergnet


Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!