• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 17. Generating Web Pages from Ta... > Exporting Table and Query Datasheets...

Exporting Table and Query Datasheets to HTML

Northwind.mdb's Suppliers table is a good choice for exporting to a Web page because it contains relatively few fields and records. The Suppliers table also includes four hyperlinks, two of which link to sample home pages in your …\Office\Samples folder. To create a formatted Web page from the Suppliers table, follow these steps:

  1. Open Northwind.mdb, if necessary, and select the Suppliers table in the Database window.

  2. Choose File, Export to open the Export Table 'Suppliers' As dialog.

  3. Navigate in the Save In dropdown list to the …\Office\Sample folder or in a folder of your Web server, such as …\Wwwroot.

  4. In the Save as Type dropdown list, select HTML Documents (*.html, *.htm), as shown in Figure 17.1. The table name is the default file name. UNIX servers commonly use the .html extension, while .htm is more common for Windows NT 4+ servers. Internet Explorer (IE) 5.0 handles .html (the default) and .htm extensions equally well.

  5. Selecting HTML Documents enables the Save Formatted check box, which you must mark to include Access 2000's automatic HTML formatting. When you mark the Save Formatted check box, the Autostart check box is enabled. Mark the Autostart check box to have IE 5.0 or another default browser display the page when exporting finishes (see Figure 17.2).

    Figure 17.1. Selecting HTML Documents as the format for exporting the content of an Access 2000 table.

    Figure 17.2. Specifying HTML formatting with the Save Formatted option and opening the exported .html file in your default browser with the Autostart option.

  6. Click the Save button to close the Export Table 'Suppliers' As dialog and begin the export process. Click OK to close the HTML Output Options dialog, leaving the HTML Template text box empty (see Figure 17.3). The section "Using HTML Templates" later in the chapter describes how to base the design of your Web page on an HTML template.

  7. When the formatted Suppliers.html Web page automatically appears in your browser (see Figure 17.4), scroll to the right to display the Home Page table column. If you saved the HTML file to …\Office\Samples, click one of the local hyperlinks (CAJUN.HTM or FORMAGGI.HTM) to test the links to the sample Web pages in your …\Office\Samples folder.

    HTML formats hyperlinks with <A HREF=location> tags that include the location of the linked document. If you saved the HTML file in folder other than …\Office\Samples, the CAJUN.HTM and FORMAGGI.HTM links don't work, because these relative links don't include a path prefix.

    Figure 17.3. You can initiate a find in a Approach through variety of ways.

    Figure 17.4. IE 5.0 displaying the formatted Web page created from the Suppliers table.


    HTML uses tags to identify the beginning and end of HTML documents (<HTML> and </HTML>), titles (<TITLE> and </TITLE>), and other elements of the page. HTML 4.0, the current version of HTML when Microsoft released Access 2000, has hundreds of tags for formatting, creating control objects on pages, and other uses.

    → Look for Special Edition Using HTML 4, Fifth Edition by Molly Holzschlag from Que Publishing, ISBN 0-7897-1851-0 for more information on using these and other tags to create Web pages.

  8. Choose View, Source from IE 5.0's menu to display the HTML source for the Suppliers.html file in Windows Notepad (see Figure 17.5). If the size of the file is larger than about 50KB, you get a message that the file is too large for Notepad and are given the option to open the file in WordPad.

    Figure 17.5. The first few lines of the HTML source for the Suppliers.html file.

  9. Close Notepad and your browser, and then return to Access.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint