There are four steps to it, which are defined below:
Click on External Data ribbon, go to the "Import" section and click on XML file option.
Use the browse option to go to the location where the XML file is located from which data needs to be imported. Click Open and then OK.
Access will scan through the file and display the structure of the table to be created. The Import Options includes the following options, namely Structure Only / Structure & Data / Append data to existing table. In our process we will choose the option of both structure and data.
If you plan to import the same file agian in the future then you can check the box "Save Import Steps".
Now you can double click on the table that is created and would be able to see the structure and the data in it i.e. imported from the XML file.
Download VietSpider3_16_XML_Windows.zip or VietSpider3_16_XML_Linux.zip
Actually, the New Web Query function does not work on this web page. It always rejected with fatal error "This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar". Any further idea to solve it. Thanks in advance!
I wrote a program that loops through a spreadsheet, goes to the right webpage and extracts the fields that I want saving it in the corrisponding cells. I designed this originally to do a crapload of Zillow searches. I'm not selling my code, but if itis a onetime project and you need me to run it for you. Please email me at Rogie3@yahoo.com. I used Visual Basic and it does about 1200 searches per hour.