I would like to download web data using Excel. The data is presented
in only small chunks at the time, so there are many pages to download.
The data is in a table, not readily down loadable by the built in web
query. Also there are over 500 pages to be downloaded, not very doable
manually.

Any ideas would be appreciated. The data is on the following pages.

http://content.usatoday.com/news/nat.../~/~/rank/~/1/

About 538 pages.

Thanks,

Peter.