Lynn Pettis (4/3/2013)

---

erikd (4/3/2013)

---

Lynn Pettis (4/3/2013)

---

And what happens if you make the phone number field varchar(8)?

Heh. Curiously, I can use Python to split the file up (opening the whole file with any of the programs I have available is impossible; the computer comes to a screeching halt), and the split files seem to agree with the \ n row terminator. Maybe I'll try using it to re-save the whole thing to one file?

When I use any length short of nvarchar(max), I get the truncation error I posted before, up to and including varchar(8000).

Worth a shot.