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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2005-01-25 : 09:56:08
|
| my bulk insert code isn't working, here it is:bulk insert Returns FROM 'c:\test\NWCTRN15623608.012405.043117.txt' WITH (FIELDTERMINATOR='',ROWTERMINATOR='{CR}{LF}')It's basically a file with no spaces so i just want each row to act as a record. when i run my code, only the first line gets inserted into the db?! is there a problem with my row delimeter? this delimeter works when i use it with the dts import/export wizard...thanks |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-25 : 10:13:56
|
| Huh?Did you tryBULK INSERT Returns FROM 'c:\test\NWCTRN15623608.012405.043117.txt' WITH (FIELDTERMINATOR='',ROWTERMINATOR='\n')Brett8-) |
 |
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2005-01-25 : 10:19:42
|
| actually, just tried \n before i read this and it works great. thanks! |
|
|
|
|
|
|
bulk insert