Results 1 to 2 of 2
  1. #1
    cupanther is offline Novice
    Windows 8 Access 2003
    Join Date
    Feb 2013
    Posts
    1

    Creating database from multiple HTML files

    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.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Research.

    Google: Access 2003 import html

    Start with http://office.microsoft.com/en-us/ac...005187610.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sending HTML files via Access to Outlook
    By Yann63 in forum Programming
    Replies: 4
    Last Post: 02-13-2014, 05:34 PM
  2. Report Sent as HTML Body - multiple pages
    By chris.williams in forum Reports
    Replies: 3
    Last Post: 09-15-2012, 07:18 PM
  3. creating database with multiple column
    By ultimate in forum Database Design
    Replies: 27
    Last Post: 07-21-2011, 02:49 PM
  4. Creating an HTML report as a single page
    By Harle in forum Access
    Replies: 2
    Last Post: 01-22-2011, 11:18 PM
  5. Import HTML files into access
    By mccrimmon in forum Programming
    Replies: 0
    Last Post: 02-15-2010, 03:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums