Update SQL table with SharePoint Excel file data automatically
This is probably an extremely rare circumstance, so I’m writing it down so I don’t forget how I did this. I recently built a simple solution for my company called “Work & Win”. Basically it’s a slot machine game that allows one random employee per day to win a variety of pre-determined prizes. Initially, I set up the prizes table in the database so it could be managed through a web UI, which means the application reads from the database…