How to import csv file to SQL server

Question

---

I wanted to import CSV file to SQL database through windows application. In that  fields are multiline and  are enclosed in double quotes.(Excel file looks like below)
Only problem is how to handle multi line fields ,as they are terminated by new line.

 

I wanted to save it , as it is in SQL database. Means second column's first row data must be as it is in SQL database.