Taking numbers off a website and importing them into Excel? Possible?

D

DrSues02

I have Excel 2000, and I don't see any of the arrows that you ar
talking about. When I input the website name, it takes me to an Exce
sheet with all of the numbers from the website. Although I guess I ca
make this work, it has none of the formatting or tables that ar
associated with the website and is very rough.

Is there a way to ONLY get the data from that particular table from th
website instead of the entire website, and then import just that dat
into Excel?

DrSues0
 
S

scottymelloty

Have you gone to the website by going through the import external dat
option and select new web query??

Not sure about excel 2000, but it should bring a window up and this i
where you enter the website address this takes you to the desire
website and you can select the desired bits of data by selecting th
yellow arrows, it works for me no problems and just brings up th
table on its own with all the numbers in it nice and nea
 
Top