Copy data from Excel sheet to SQL Server 2012

Copy data from Excel sheet to SQL Server 2012

Using copy method:

Step 1:

Verify the all values in the excel sheets are valid

Step2:

create a table name as per the excel sheet

Step3:

Open the table with right clicke table name and click open table

Step 4 :

Copy all data from excel sheet by right click on mouse of excel sheet

Step 5:

Paste the data from open table in SQL Server

Step 6:

Wait for all the data to paste to SQL Server table

Step 7:

After verify this close the table

Step 8:

Now query the tale to ensure all the data present in table