There are many ways to skin a cat, have you thought of using vbscripting to update the sql database directly at the click of a button. You could build a macro that would take the data and insert it into the table you require.

Here is a link I found using Google http://database-programming.suite101.com/article.cfm/how_to_use_sql_statements_with_vbscript that might help you with that approach.

If however, there is no requirement for you to be updating during the day everytime the user saves the file, ie. you can run the package at night for the next day. Then Ells idea will work like a charm.

If you need to update during the day, and can't use vbscripting, you are looking at a lot of work. File watcher tasks, stored procedures to check data integrity, messaging to users that haven't saved the spreadsheets in the correct format, etc.

Good Luck! 😉