Excel to SQL

If you have worked in an IT department it is more than likely that you have been asked, more than once, to update a database from an Excel spreadsheet.

Business user’s preference to use Excel as their primary tool for creating these files is perfectly understandable; after all it is great tool for quickly adjusting, copying and transforming data. However getting the Excel file into a SQL database and process the data requires many steps and is often a tedious and time consuming prospect.

In this new application scenario we illustrate how you can automate excel imports in a few easy steps using the Boomerang Notification Framework.