G Guest May 20, 2005 #1 How would I go about extracting information from an Internet Web Page and putting it into an Access 2003 table?
How would I go about extracting information from an Internet Web Page and putting it into an Access 2003 table?
? =?iso-8859-1?Q?J=F6rg_Ackermann?= May 20, 2005 #2 rcassady59 said: How would I go about extracting information from an Internet Web Page and putting it into an Access 2003 table? Click to expand... 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
rcassady59 said: How would I go about extracting information from an Internet Web Page and putting it into an Access 2003 table? Click to expand... 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