Excel Sheet to Sql Server Table

I have written a small utility which will import your excel sheet in the SQL Server tables. Although there are many ways and tools available on the web through which you can import your excel or csv file data into the sql server. This utility provides some advance features which you will like.

The main features of this utility is :

Features

1.  It will import multiple files in one go. Simply specify the location of the files in the config file and it will import all files data into the sql table and archive those files into another folder as specified in the config file
2. It supports all versions of the excel and SQL Server
3. It takes the table name same as the excel sheet name so while importing the data make sure  the table name and excel sheet name matches .
4. If the table doesn't exists in the database then it will create the new table with the same structure and data type as specified in the excel sheet.
5. If you are getting excel files regularly and you want to import these data then you can easily schedule this utility to run automatically at the given time interval.
6. Easy  to configure.

Limitations

1. It imports only single sheet per excel
2. Only supports MS SQL Server
3. Table name limited to sheet name. If sheet name doesn't matches with Table name then it creates new table
4. If the excel sheet column contains both numeric and string data then it will ignore the integer value , so you need to explicitly specify the data type of that column to text. (Its excel driver issue)

Updates

Further updates to this utility will bring new features such  that reading all sheets of excel file and creating multiple tables of the same file. 

If you feel something extra needs to be added in this tool then feel free to write us at admin@dkumar.co.in or leave your comment here and we will update this tool with new features.

Source code of this utility is available on request. Terms and condition apply. Before downloading and running this utility please make sure you have .net framework installed on you computer. This tool is developed using Visual Studio 2013 ultimate edition on windows 8.1 64 bit.This utility is copyright to DKTech and all rights reserved.

Download the Utility by clicking on the below Image