Importing data from website to Excel!!!!???

Hi,

I need some help otherwise I'm going to be here forever. I need to be able to import the addresses from the following website below:

http://www.scotlandfoodanddrink.org/20806

I have tried a few things but it hasnt come back with the correct data, there are either email addresses missing or other data missing.

There must be at least 1400 addresses to copy and paste and its all over the place and its taking me forever.

Can anyone help, it would be greatly appreciated

Many Thanks

Emma

re: Importing data from website to Excel!!!!???

Do you have any programming or scripting experience? Because there's really no other way to do it than either write a script or program that will make web requests to each page, download the response as HTML, and strip out the content you want.

In short, there's not a program or anything like that for you to quickly use. Good luck.

re: Importing data from website to Excel!!!!???

Hello InsertAlias,

I have no experience with programming or scripting, so looks like I'm going to have to grin and bear it and get stuck in.
Thanks for your help anyway
Regards
Emma