Importing Data from Excel into SQL Server

Sometimes importing data from Excel into SQL Server can be tedious. I have documented an easy way to import data from EXCEL into SQL Server. PFB the process

 

 

 Select the excel sheet which contains the data you want to upload in the tables.

 

 

 

Select proper source and destination and check if Data is aligned properly by clicking on preview button.

And then click on finish and check the upload status.