you only need to Linked (linked table) your Excel file to ms access.
and instead of creating table, create a Query (Total query) that will return
Unique TeamID and TeamName.
you can then make "other" queries, join to the above unique teams (by TeamID) and
retrieve pertinent informations.