Import webpage data into Excel spreadsheetSolved/Closed

Question

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.

eliza81 · Accepted Answer

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/

None · Answer

I'm looking for this too..let me know if you find it...i'll do the same

None · Answer

I found it...
this page explains everything.  It's an Excel feature.  Chose Data -->Import External Data-->New Web Query...the site will guide you through completion.
https://exceluser.com

Jeffrey · Answer

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!

vikram reddy · Answer

hi,
i want display my dataset in excel sheet using windows application in c#.

Thanks & Regards
VIKRAM REDDY GADDAm

roheet143 · Answer

yes I have done the same thing what u want but the only thing is u have to login again and again throughthe import function where u want to import the data

Ringo · Answer

Same problem faced me that Excel Web Query not returning data from table constructed from javascript.  I am trying to make a query that will pull data off of below URL, however if I select the table no data is returned by reject message ""This Web query returned no data. To modify the query ....".  I think it might have something to do with the fact that the table is contained within some javascript tabs.

http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&l=en&s=gen&servicetag=3D9XP81&~tab=1

Really all I need from this page is the days left number in the bottom right. 

Thanks and Regards,
Ringo

Darkman · Answer

i think you can copy all data you want
then on the Excel data Worksheet Right Click -> Paste Special, select Text then OK
it works with me ( Windows XP SP2, Microsoft Office 2007, Mozilla Firefox )

Roger · Answer

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.

jamie · Answer

Hi this article,may be helpful "how to export a iamge into excel using asp.net" in http://netprogramminghelp.com

vietspider · Answer

You can use VietSpider XML from

https://sourceforge.net/projects/binhgiang/files/

Download VietSpider3_16_XML_Windows.zip or VietSpider3_16_XML_Linux.zip

VietSpider Web Data Extractor: Software crawls the data from the websites ((Data Scraper)), format to XML standard (Text, CDATA) then store in the relational database. Product supports the various of RDBMs such as Oracle, MySQL, SQL Server, H2, HSQL, Apache Derby, Postgres ...VietSpider Crawler supports session (login, query by form input), multi-downloading, JavaScript handling, proxy (and multi-proxy by auto scan the proxies from website)...

Pasha · Answer

Use ctrl C and ctrl V. That works for me

Import webpage data into Excel spreadsheet

12 responses

Similar discussions

Subscribe To Our Newsletter!