Hi,
I'm hoping to get guidance on where I can find resources on using an Excel workbook to Update an Access Database.
Let's say for example the database manages basketball player stats...
and
I want to use an excel workbook to enter the info/stats such as points, rebounds, steals etc..., to click a button and have that info appear now in access.
But when the Database updates, I want understand how to have it so that...
1. any info I enter overrides any previous data for that player
-as well as -
2. add a new line of data for the player (keeping the previous data)