Question: how to automate import data from excel to sql server?
Answer: 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.