myhousekey Posted March 20, 2009 Share Posted March 20, 2009 I am trying to automatically download our NCAA tournament challenge group results from the ESPN webpage into an Excel spreadsheet. I can go thru the process of setting up a web query in Excel to get to the ESPN page but the problem I am having is that it will only pull the first 50 entries since that is all that is shown on the first page of our group. Entries 51-100 are on page 2 and so on... Any ideas on how to edit the URL for the web query so that it pulls all rows of data instead of just 1-50? I've tried seperate queries for page 1 and page 2 but it ends up still just pulling the same data (entries 1-50). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.