Print Page | Close Window

ImportHTML.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=341
Printed Date: 20 Jul 2018 at 1:50pm


Topic: ImportHTML.mdb (intermediate)
Posted By: Roger Carlson
Subject: ImportHTML.mdb (intermediate)
Date Posted: 01 Aug 2008 at 3:16am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

ImportHTML.mdb

This sample illustrates how to use the LineInput statement to import text from a text file in an extremely unconventional format. The file is an HTML file, and the code searchs for the HTML tags to find specific information and puts that in a field.

The text file "Details.htm" must be in the same directory as the application. You will notice that there are large gaps of empty space in the file.

There is also a status meter to show the progress of the import.
 
Download
Access 97 (140 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/ImportHTML97.zip - uploads/5/ImportHTML97.zip
Access 2000 DAO (128 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/ImportHTML2k.zip - uploads/5/ImportHTML2k.zip

 



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window