Open a database, or switch to the Database window for the open database.
To import HTML tables or lists, on the File menu, point to Get External Data, and then click Import.
To link HTML tables or lists, on the File menu, point to Get External Data, and then click Link Tables.
In the Import or Link dialog box, in the Files Of Type box, click HTML Documents (*.html;*.htm).
Click a shortcut on the Places Bar or click the arrow to the right of the Look In box.
Select the drive and folder where the HTML file you want to import or link is located, and then double-click the file name.
Follow the instructions for the Import HTML Wizard or the Link HTML Wizard. Click the Advanced button if you want to edit an import/export specification or specify different file and field formats.
If your HTML file contains more than one table or list, repeat steps 1 through 5 for each table or list you want to import or link.
Notes
By default, Microsoft Access converts an HTML hyperlink address to a Hyperlink data type column, but only if all values in a table column or list contain a hyperlink address defined by an <A HREF> HTML tag. You can change the data type when using the Import HTML Wizard or the Link HTML Wizard. For more information on hyperlink addresses, click .
Microsoft Access ignores GIF and JPEG images embedded in the HTML tables or lists.
A table embedded within a table cell in an HTML file is treated as a separate table when you import or link. A list embedded in a table cell is treated as the contents of a cell, and each item in the list is delimited with the carriage return/line feed characters.
For data that spans rows or columns in an HTML table, Microsoft Access 2000 duplicates the data in each cell, whereas Microsoft Excel 2000 stores the data in the first or upper-left cell, and then leaves other cells blank.