Productivity Tools

Tools written by an IT business manager, a passionate developer.

Excel2SQL – to be updated

Module takes all excel files in given directory and push the content to database.

Module opens all excel files in given directory, reads the content, create tables which and pushes data to the newly crated tables.
Name of the table is the same as name of the excel file, and columns names are the same as headers in the excel sheet.

If we have following excel file:

And we will invoke command:

Import-ExcelToDB -SqlInstance ".\sql2017" -DatabaseName "EcoVadisDT" -DatabaseDirectory "d:\bin\DB\" -verbose

After execution

In database we will have data: