How to import data from excel into sql server?

The simplest way is using the SQL Server Import and Export Wizard. In SSMS, just right-click your database, go to Tasks, and select Import Data.