O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing Data from HTML Tables

Access 97 includes the capability to import or link data from an HTML table to a Jet 3.5 table. This feature appears to have been included in Access 97 for HTML symmetry; the theory apparently is that if one can export to HTML, one also should be able to import from HTML. Few Access users are likely to employ this feature because relatively little useful tabular data is available on the Internet. For completeness, however, following is an example of importing data from an HTML page created in the section Exporting Table and Query Datasheets to HTML earlier in this chapter:

1.
Choose File, Get External Data,Import to open the Import dialog. Select HTML Documents (*.html, *.htm) in the Files of Type drop-down list ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required