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 ... |
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
