CODE EXAMPLE FOR SQL

import data from excel to sql server automatically

Step 1 – Create a Project. ...
Step 2 – Create a Connection to your SQL Server Database. ...
Step 3 – Create a Table. ...
Step 4 – Create an Excel Connection. ...
Step 5 – Create a Data Flow Task. ...
Step 6 – Creating the Excel Source. ...
Step 7 – Removing Rubbish Data. ...
Step 8 – Piping the 'OK Data' into a SQL Server Table.