I am wondering that best way to move data from excel to sql. Right now there is an excel spreadsheet the users use to fill in information. Each time they save this spreadsheet with a unique name to a folder. I would like to take the information entered on this spreadsheet and insert the records into a sql table. Appending the information to the table each time a new spreadsheet is created. I would also like this insert to sql to happen each time they save the spreadsheet. What is the best way to do this in excel? Or should I think of accomplishing this some other way? Any feedback you could provide would be greatly appreciated.

I suggest you build a front-end application to your database. Since you [appear to] know how to code in Excel - Access shouldn't be too much of a step up for you.