Question: how to import data in database in sql server?
Answer: Open SQL Server Management Studio Express and connect to your database.
Right-click on your database and select Tasks > Import Data... from the side menu.
The SQL Server Import and Export Wizard will open.
Choose a data source for the data you want to import from the drop down.