how to scrape a webpage for data.

Posted on 2011-04-25
Last Modified: 2012-05-11

I need to scrape a webpage for data. I need just one table.

Question by:samprg
    LVL 8

    Expert Comment

    What do you mean?
    LVL 67

    Accepted Solution

    The Microsoft Jet driver can do that (if on MS OS). For test you can use Excel: Go into Data > Import External Data > New WebQuery, and provide the link (and press Start). Then click on the yellow arrow pointing to the table you want to retrieve - but watch the blue frame, which determines what is interpreted as HTML table. After pressing Import, that table will be displayed in Excel. It is still connected to the source, so you can simple update the values using the Context Menu > Refresh Data  somewhere in the data area.
    LVL 1

    Expert Comment

    I'm assuming you are going to write code to do this ? If so have a look at

    This guy then wrote more code to dig out the parts he wanted, but  more elegant solution would be to use XSLT if you know it. A regular expression may also obtain the info you need.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    In my previous two articles we discussed Binary Serialization ( and XML Serialization ( In this article we will try to know more about SOAP (Simple Object Acces…
    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now