Extracting data to microsoft access

I am trying to compile a list of devon schools that I can export and open in a microsoft access file for the purpose of direct mailing...Is this possible/allowed? If so can someone tell me how to do it?

or the information I want can largely be found here http://schoolsfinder.direct.gov.uk/ but it can only be viewed via a browser, does anyone now how to open the information into a database? Thanks.

Comments

It's possible to download

It's possible to download each of the results pages as text files, open them into a spreadsheet and clean up the results.

 Flag as offensive 

Right click to Excel

In Internet Explorer right click and you should to be able to export to Excel - might need to edit a bit, but it's a start.

 Flag as offensive 

I don't think this is to be

I don't think this is to be used for direct marketing.

 Flag as offensive 

don't do it!

Schools really hate getting junk mail: it takes up the time of head teachers and admin staff,both of whom tend to be pretty pressed (just goes to show that sometimes there are good reasons not to publish data!)
The best solution is usually to politely to ask the local authority concerned to put a message in their newsletter to schools. That way, the LA filters out the real junk, and messages schools need get read in a more efficient way. And it's cheaper for you as well!

 Flag as offensive 

Spamming Schools

I don't think the purpose of opening up the flow of data is to increase the amount of mail shots that tend to get thrown in the bin. Exporting from anywhere like that then requires alot of fiddling in excel. Good Luck

 Flag as offensive 

The implications of the Big Society

Hey - this is the Big Society (BS) in action. Ordinary people having access to information giving them the power to pester people trying to do a good job. Bypassing the Local Authority is also part of the BS, thus making them superfluous, and therefore closer to redundancy.

 Flag as offensive 

Re: Extracting data

I think there is a function of importing data from a web page on either Ms Excel or Access. When you copy the result from the page, choose import from a web page. Should be work :)

 Flag as offensive 

import from webpage..not always ok

I used to import data from webpage to Access. If data is simple, i mean just text, it will be ok. But, not easy to import if they are binary, url,...I can't know exaclly why is was.

 Flag as offensive 

Extracting data to microsoft access

I think there is a function of importing data from a web page on either Ms Excel or Access. When you copy the result from the page, choose import from a web page.

 Flag as offensive