I want to export data from SQL server to CSV format but having issue with ntext dataype in some tables columns.
data is ntext
column is html with html tags like br , li etc..
BRANDS SUBSECTION:BEAUTY, FRAGRANCE, GROOMING & HEALTH
Acticare
abc def PR
abc def T: 020-0000 1230 e: [email protected]
Added Dimension Dentistry
abc def PR
abc def T: 012-3456 7689
I have tried export from SQL server direcly exporting to csv format , tried SSIS package,even tried converting to varchar then export but when exported data is not showing correctly.
How do I export data to excel/csv having column data type ntext containing html tags ??