Web site data with MS Access Database table

[kacocal]

Hi all,



I am wondering if there is a direct way to import a web page data into MS Access Database 2010 table.

Please advice.

Thank you.

[Ruegen]

You can do this by parsing the data from the website.

The easiest way would be through XML or JSON - that way you could directly parse the data. But not all web sites have them available.

Does the website provide that?

VBA would be required in order for it to work...
http://stackoverflow.com/questions/1...-xml-using-vba

[kacocal]

Hi Ruegen,

Thank you for the comment. However, I am very new to MS Access and don't know whether the webpage support XML or JSON. How can I know that?

Please advice.

Thanks,

You can do this by parsing the data from the website.

The easiest way would be through XML or JSON - that way you could directly parse the data. But not all web sites have them available.

Does the website provide that?

VBA would be required in order for it to work...
http://stackoverflow.com/questions/1...-xml-using-vba

[Ruegen]

Hi Ruegen,

Thank you for the comment. However, I am very new to MS Access and don't know whether the webpage support XML or JSON. How can I know that?

Please advice.

Thanks,

You'll have to search the website or the contact the website developer to see if any are provided. There really isn't any other way I can think of to find out if it is provided.

You are asking for a page that is formatted in json/xml as apposed to the regular .html page.

If you want to pursue this you really need to study on both json & xml and use the provided xml parser in VBA (also more learning).

[ItsMe]

If the Webmaster does not offer an API another option would be to automate Internet Explorer via the Microsoft HTML Object Library. Here is an example of interacting with a webpage using the library.
https://www.accessforums.net/modules...tml#post246465