Question: how to import data from excel to table in sql server 2014?
Answer: Now start SQL Server Management Studio and connect database engine and expand the database where you want to import the data.
Now follow wizard steps carefully.
Now select Microsoft Excel from Data Source drop down and click next.
Browse the path for excel file and select Excel version and click Next.