I have been trying to accomplish something that I am not even sure is possible. I am trying to automate the process of importing a Excel sheet (Excel 2008) to a SQL 2012 database. I created a custom web part in SharePoint to include a browse feature, text box for path, and a submit button for users to select an excel file from their hard drive. This excel file is be imported into a temp table, be manipulated in the table, and then inserted into another table.
I assume that the SharePoint credential should be assigned to a svc account or active directory that grants the user access to the SQL server to allow the inserting data into the temp DB.
I made the web part, but I am not even sure if I am on the right track because I am having issues with the SQL import script.