Basic utility to fetch data from a couple of websites and store the data into an Access database.
Ultimately I want to run queries to statistically analyze accuracy of game pickers on wagerline.com.? I can write the ad hoc queries, but I need help getting the data from the websites into the Access tables.
I would probably write the project in .NET, but it can actually be written in any language or tool? as long as I can support it.
## Deliverables
Since football season has started, I'd like to have this done in a week or two.?
Here are the websites I'm looking to import/screen scrape.
For the results of the game... loop thru the season from 2005-2007 storing the week number or dates.
<[login to view URL]>
For the pick percentages.... loop thur the season from 2005-2007 storing the week number or dates.? Also store the from select_type 0, 1, 2.
<[login to view URL]>
You can design the database, or I will give you the database... either way.?
I just need to make sure that I can run the ad hoc queries I need to run.
I have started by storing an excel spreadsheet with the team names, conferences? and stadiums types.? I can send that to you if needed.