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.
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.
Manas MohapatraPosted Dec 1, 2016, 8:19 AM