obtain addresss from a website and geocode

Hi all, Further to my last project, I also require an additional mySQL database table populated and geocoded with latitude and longitude However, this time the data is freely available at the UK gov website. [login to view URL] there are nearly 56,000 records there, but they are only given a page at a time. the site allows for downloading the entire database, but when I do so, I get badly formated data. So the project is to get the data and return a mySQL Table with 56K records with the folllowing data Establishment Name, LocalAuthority, Town, Status, Type, telephone number and postcode, and of course, latitude and longitude, geo coded from the post code.