Using excel workbook to update access database on conditions

Hi All,


I'm looking to accomplish the following...


1. I want to use an Excel work book that will allow me click a button> to select another excel file (With my stored data) to input into access> and Upload that selected files data to the appropriate Columns in Access.


2. The Data I am working with is NBA Stats for NBA Players.
-If the Player exist in the database - and the stats are the same --pretty much do nothing.
-If the player does not exist in the database and is present on the new data set I am importing (via the Macro workbook), Insert the new row.
-If the Data being does not include all the players existing in the database- then the players in the database move to in-active


Basically the Data being imported will determine how the database is updated/behaves


How Can I accomplish this using a macro?


The reason for the work book is to have end users use it. They should be able to click a button - which will then prompt them to select the file from the folder...Whereby one of the three situations happens row for row...


Sample Data attached...

Sample Data to be updated...
DATA SET DATE PLAYER FULL NAME POSITION OWN TEAM OPP TEAM V MIN BL PTS
2013-2014 Regular Season 10/29/2013 Jason Maxiell PF Orlando Indiana R 21.32 5 2
2013-2014 Regular Season 10/29/2013 Maurice Harkless SF Orlando Indiana R 18.5 4 3
2013-2014 Regular Season 10/29/2013 Nikola Vucevic C Orlando Indiana R 25.65 3 4
2013-2014 Regular Season 10/29/2013 Arron Afflalo SG Orlando Indiana R 27.98 2 6



This is cross-posted in accessforums here:

http://www.accessforums.net/showthread.php?t=58137

I have attached a sample database with headings in the crosspost.