Windows 8 
Access 2003
I am a complete novice at building a database, so of course I want to something complicated like create a database from multiple HTML files, and I have no idea how to get started.
I would like to be able to have more detailed stats than are available on the ECHL's site [www.echl.com].
The league has Official Game Reports available, which contain the data I would need [an example of one can be found at http://www.echl.com/stats/official-g...p?game_id=9619 - the rest can be accessed from http://www.echl.com/stats/schedule.p...son&team_id=-1].
I am not a part of the ECHL or any of it's member teams, so the only way I have of getting the data is to get it from their site; I am not sure if there is a better database available to the league, but, as a member of the general public, I would have no access to it anyway.
I would like to be able to have the data contained in every Official Game Report pulled into a single database, without having to manually set up tables for each one - basically, I want to have a format set, and for either Excel or Access to be able to pull data, following that format, from all of the HTML files.
I can use an add-on in my browser to download all of the Official Game Reports, so I have over 500 HTML files saved on my hard drive.
The season is currently progress, so virtually every day there are more Reports to pull, and I would like to be able to .
My goals would be to be able to identify and query the following information:
* Referees
* Three Stars
* Each goal scorer, the players that assisted on the goal (if any), the type of goal (Power Play, for example), and which players were on the ice for each time at the time of the goal (the numbers, separated by spaces, correspond with the jersey numbers for each team) - I would love to be able to determine which players have the most success against a specific goalie, or which pairs, trios, or full lines work best together.
* Stats for each player on both teams (Goals, Assists, Plus/Minus, Shots, Penalty Minutes, and TOI for skaters, Shots Against, Saves, and Goals Allowed for goalies)
* Information for each penalty called (player, minutes, offense)
* Total stats per player (I would like to be able to determine each goalie's Shots/TOI, for example, and that requires aggregated data from all games)
I would also like to be able to keep this going for future seasons, so I need to be able to store the data on a season-by-season basis as well.
Is Office 2003 Professional Edition capable of doing this?
Do I need to download another program to help me with this?
Where would I even start?
Any help is much appreciated.
Reply With Quote
