How to extract info from Internet Web Pages and put it in Access?

R

rcassady59

How would I go about extracting information from an Internet Web Page and
putting it into an Access 2003 table?
 
J

Jörg Ackermann

rcassady59 said:
How would I go about extracting information from an Internet Web Page
and putting it into an Access 2003 table?


First you have to download the html-code to a
local string-variable
You can use:
- IE-Automation
- MS-Webbrowser-control
- XMLDOM
- APIs (wininet.dll)

Google should help you to get some info

After downloading you'll have to parse the code
using access-string-functions

Left, Right, Instr, Mid...

Acki
 
Top