asked
Importing excel spreadsheet to Sql 2012 using an SSIS package
I have 4 Excel spreadsheets representing schedules for staff for a particular month. These schedules can change and are modified quite regularly. We need to export these spreadsheets to SQL tables. My plan is to have a file browser-like application that the user will use to navigate to the file that they want to export, select the file and export to a SQL table. In the background I am hoping to achieve this as follows. When the user selects the file to export, the file path should be saved as a variable in a stored procedure which is then sent to the package and then the package will excute using the select file path as a parameter. I am new to SQL and SSIS and am not sure if this is even possible. If it isn’t, does anyone have a better way of doing this? I am going for the app approach instead of a sql job that’s on a schedule because we need the user to export the schedule as soon as they update it. The data that is in the SQL tables is used by another desktop application that the company uses for their schedule. I really need some help on so any suggestions are welcomed. Am using visual studio 2010 to create the package and SQL server 2012
You can let your users update the tables directly from Excel using a tool like [SQL Spreads][1], an Microsoft Excel to SQL Server AddIn. It needs to be a rather straight Excel-table to SQL Server-table update, so if you have a complex spreadsheet I don't think it is the right solution. You can download a a free trial [here][2]. Disclaimer: I am the author of this tool. [1]:
http://sqlspreads.com/ [2]:
http://sqlspreads.com/download-sql-spreads/
18 People are following this question.
