468,550 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

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
Nov 9 '09 #1
2 1460
Curtis Rutland
3,256 Expert 2GB
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.
Nov 9 '09 #2
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
Nov 10 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Michal Maciejczak | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.