Question: how to import data into table from excel in sql server?
Answer: Open SSMS (Sql Server Management Studio) and connect to the database where you want to import your file into.
Import Data: in SSMS in Object Explorer under 'Databases' right-click the destination database, select Tasks, Import Data.