Tuesday, July 29, 2014

How To Exporting Database Objects to HTML in Access 2003

In Access, the Export command allows you to save a table, query, form, or report as a Web page. If the page is saved in HTML format, it represents a snapshot of the data at the time you created the file. If your data changes, you must export it again if you want the Web page to be current.

Export to an HTML File

graphics/1_icon.jpg
Open a table, query, form, or report.
graphics/2_icon.jpg
Click the File menu, and then click Export.
graphics/3_icon.jpg
Click the Save In list arrow, and then select a location for the file.
graphics/4_icon.jpg
Enter a file name for the Web page.
graphics/5_icon.jpg
Click the Save As Type list arrow, and then click HTML Documents.
graphics/6_icon.jpg
Click Export All.
graphics/7_icon.jpg
Select a HTML Template check box.
graphics/8_icon.jpg
Enter the name of the HTML template you'll use for this Web page (if one exists).
graphics/9_icon.jpg
Click OK.
graphics/10inf07.jpg

Did You Know?

You can use Export format. Tables, queries, and forms appear as HTML tables, but a report appears in HTML format with the same layout it had in Access.
You can use HTML templates. Templates are usually stored in the \Program Files\Microsoft Office\Templates\Access folder. See online Help for more information on creating your own templates.