I am looking for syntax commands which allows me to collect external data from web site by means of a "link" or "importing" in to my sql database.

On each of the sites below, there are three tables I'd like to get the data; Offense, Defense, and Special Teams.
Dallas Cowboys Roster - NFL Football - ESPN
NFL Football Teams, National Football League Teams, Football Teams - ESPN
New England Patriots Roster - NFL Football - ESPN
Pittsburgh Steelers Roster - NFL Football - ESPN

If you know of the syntax commands I can use in a SQL querry / database, please feel free to inform me.