View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Works fine for me, although one have to do some editing since it imports
some trash as well (I would import it, then select the table itself from the
import and copy and paste into a new sheet, then import the next 50 and so
on) but I got the first 50 players with their stats. I did as follows,
dataget external datanew web query, then I put in the web address, select
only the tables,
and no formatting. This is excel 2000, I have xp and 2003 at home but I am
sure I can do it using them as well.
I did it with the first 100 players, first imported 50, copied and pasted,
then imported next 50, copied and pasted below the
first 50

--

Regards,

Peo Sjoblom


"Jambruins" wrote in message
...
If I try and use a web query with the following site
http://www.sportsline.com/mlb/stats/...n/yearly/MLB/P

I get a message that says the web query returned no data. I click on the
arrow right by player and it highlights all the players names and their
stats. Anyone know why it doesn't import the data into excel? Is there

too
much data? Thanks