Import or link (read-only) HTML tables and lists

Import or link (read-only) HTML tables and lists

  1. Open a database, or switch to the Database window for the open database.

  2. 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.

  3. In the Import or Link dialog box, in the Files Of Type box, click HTML Documents (*.html;*.htm).

  4. Click a shortcut on the Places Bar or click the arrow to the right of the Look In box.

  5. Select the drive and folder where the HTML file you want to import or link is located, and then double-click the file name.

  6. 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.

  7. 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