Import webpage data into Excel spreadsheet

Solved/Closed
Jeffrey - Oct 22, 2008 at 10:09 AM
 stuccohound - Jul 23, 2010 at 03:50 PM
Hello,
I am attempting to import the web page data from "http://bet1.hkjc.com/racing/pages/odds_wp.aspx?date=19-10-2008&venue=HV&raceno=1&lang=en" through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks.

12 responses

There are four steps to it, which are defined below:
Step 1:
Click on External Data ribbon, go to the "Import" section and click on XML file option.

Step 2:
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.

Step 3:
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.

Step 4:
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.

Eliza
http://burnignorance.com/xml-tricks/access-2007-import-xml-data-into-a-microsoft-access-database/
28