從Excel輸入資料到Sql Server裡的Line break問題; Insert data from excel to Sql server may encounter line break replace problem.
Excel : ctrl+J press ctrl+f to open the find an replace box, press ctrl+J, you will see a dot at find what field. If Ctrl + J does not work, press the Alt key, and type 0010 on the number keypad (do not use the numbers above the letters) SQL Server : CHAR ( 13 ) + CHAR ( 10 ) repace by this character. End