Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2002-10-27 : 13:45:21
|
| I am trying to import a file, but unfortunately it is not accepting the normal Row Delimiter (it's a text file). I've tried the '{CR}{LF}' and 'VBCRLF' and '\n' and every other option in the drop down menu...Does anyone have any other suggestions of ones to try? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-27 : 16:50:08
|
| If the file came from a Unix/Linux system, it is probably using a Unix line terminator (\r or {LF}, SQL function CHAR(10)) If you're using DTS to do the import it will have an option to use {LF} only as a row terminator. |
 |
|
|
|
|
|
New line character trouble