Question: how to import data using sql server management studio?
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.