Question: how to import data from csv file to table in sql server?
Answer: Right click on your database and select Tasks -> Import Data... For the Data Source, select Flat File Source . Then use the Browse button to select the CSV file. Spend some time configuring how you want the data to be imported before clicking on the Next > button.