Browsed by
Month: August 2013

Update SQL table with SharePoint Excel file data automatically

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…

Read More Read More