從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