Question: how to import excel sheet data into sql server 2014 table?
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.