Question: how to transfer data from excel to sql server table?
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.