Soldato
- Joined
- 19 Oct 2002
- Posts
- 3,216
Creating an Excel database from a website
There is a website: http://www.glasgowchamberonline.org
It has a list of members such as: http://www.glasgowchamberonline.org/members.asp?member=3 and http://www.glasgowchamberonline.org/members.asp?member=1578
I want to take the Name, Address, Phone Number, Email and website url and insert it into an excel spreadsheet for each entry (2-1578). It this possible in any way, shape or form?
I know that in excel you can run a web query, select the specific frame with the data for each tie and it will import the data, albeit not perfectly.
Is it possible to set a macro or something to run for pages 3 through to 1578?
There is a website: http://www.glasgowchamberonline.org
It has a list of members such as: http://www.glasgowchamberonline.org/members.asp?member=3 and http://www.glasgowchamberonline.org/members.asp?member=1578
I want to take the Name, Address, Phone Number, Email and website url and insert it into an excel spreadsheet for each entry (2-1578). It this possible in any way, shape or form?
I know that in excel you can run a web query, select the specific frame with the data for each tie and it will import the data, albeit not perfectly.
Is it possible to set a macro or something to run for pages 3 through to 1578?
Last edited: