I have a question concerning the importation and transformation of an HTML web page as an Access table. Is it possible to configure Access so that it automatically recognizes a keyword from an HTML page (e.g. expertise) and assigns the associated text of that keyword to a column? This text being one of the records associated with the HTML page. There will be other keywords such as Expiry Date and Country which I want to be automatically assigned to discrete columns.
To make myself clearer I want access to automatically recognize a keyword on a web page. These keywords are the heads of the different columns of my acces table. In a way, I want access to recreate the web page as database with only specific parts (expertise, Expiry Date and Country) of the concerned web page.
If there is, please indicate me a tutorial on the net.
Thank you for your time
Place this in a click event. Have a text box named txtURL on the form. Paste a URL in the text box and click the button to execute the code.
The source code will be printed in the immediate/debug window.
Dim objLink As HTMLLinkElement
Dim objMSHTML As New MSHTML.HTMLDocument
Dim objDocument As MSHTML.HTMLDocument
' Must have Internet Explorer
Set objDocument = objMSHTML.createDocumentFromUrl(Me!txtURL, vbNullString)
While objDocument.readyState <> "complete"