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.
Printed Date: 20 Sep 2020 at 9:53pm
Software Version: Web Wiz Forums 12.03 -

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, - find out why here .


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.
Access 97 (140 KB): - uploads/5/
Access 2000 DAO (128 KB): - uploads/5/


Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -