0

I have a .CSV file which needs to be imported into a SQL Server table by SSMS.

The file contains µg which needs to be imported as "µg".

I use import data function in SSMS.

How to do this?

Thom A
  • 88,727
  • 11
  • 45
  • 75
Zayfaya83
  • 93
  • 6
  • 1
    I wouldn't do this in T-SQL, if I am honest. It's string manipulation is poor at best. – Thom A May 17 '21 at 08:51
  • 1
    There are two obvious choices. Write code that parses your CSV and replaces the HTML encoding with unicode characters, then load the file. Or, load the file then update the table you loaded it in to to replace the HTML encoding with unicode characters. – MatBailie May 17 '21 at 08:54
  • 1
    Does this answer your question? [Is there any way to do HTML decode in SQL Server?](https://stackoverflow.com/questions/28253101/is-there-any-way-to-do-html-decode-in-sql-server) – underscore_d May 17 '21 at 08:55

0 Answers0