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.

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

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

I have zipped a proforma db with a table which is linked to your excel file. In this manner, any changes you make to the excel file is automatically changed in your database. No need to run append or update queries.

It means, I built a simple data base using your excel file. Replace the term proforma with the term example.

OP has opened a new thread in Commercial Services