Data extraction from ASP.net site

[nteeman]

Hi Guys

I need the names and addresses of all schools from
http://www.aisnsw.edu.au/Main/SchoolFinder/tabid/649/Default.aspx

It's going to be a nightmare to individually copy and paste each school from each area.

Is there a script or way to make Excel extract the data? Or at least get more data displayed per page i.e all the schools in Metro West on one page then all the schools in Metro North on another page.

Any tips appreciated...


Nic

[nteeman]

P.S. Tried emailing the contacts on the site to ask for the data and they are ignoring/not replying to my emails.

Thanks again

Nic

[Mike_O]

Hey,

I suppose you can use something like this to store the Web page content in a string:
http://www.geekpedia.com/tutorial175_Getting-web-page-content-and-headers.html

Once you have that, you can parse your string via regular expressions/XML parser or something of that nature.

Mike