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