There are many instances where you might be developing an application, but you want some seed data or business data to be populated into a table in SQL Server. Considering such a scenario, where source data resides in an excel file and you just want to import data from the excel file to your SQL database table. There are many different ways to do it, like writing a script, macro etc. But, there is a simple solution where you could just import data from excel file to SQL database just like a copy paste would work. Let’s get it done step by step.