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

Linking to HTML Files

Just as you can link to dBASE tables, Paradox tables, or open database connectivity (ODBC) data sources, you can also link to HTML files by following these steps:

1.
Right-click within the Database window and select Link Tables; this opens the Link dialog box.

2.
Use the Files of Type drop-down list to select HTML documents.

3.
Select the HTML file you want to link to and click Link. The Link HTML Wizard appears.

4.
In the wizard's first step, indicate whether the first row of data contains column headings. You can also see Access's proposed layout for the linked table (see Figure 26.4).

Figure 26.4. The first step of the Link HTML Wizard.


5.
Click Advanced to designate specifics about the linked table. The Link Specification dialog box opens (see Figure 26.5). Here you can select which fields you want to include in the linked table, date delimiters, and other specifics of the linked file. Make your selections and click OK.

Figure 26.5. In the Link Specification dialog box, you designate specifics about the linked table.


6.
Click Next to proceed with the Link HTML Wizard. In the next step, you select a field name and data type for each field in the HTML file (see Figure 26.6). Make your selections and click Next.

Figure 26.6. You can select a field name and a data type for each field in the HTML file.


7.
In the wizard's last step, you supply a table name for the linked table. Make your selection and click Finish.

8.
You then see a message that the table linked successfully. The table appears in the Database window with a special icon indicating that it's an HTML file (see Figure 26.7).

Figure 26.7. The Database window with a linked HTML document.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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