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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-10 : 08:34:34
|
| bill writes "I have to import a text file - like you can with excel. It is an ansi formatted, space delimited text file with cr-lf lines. I need to treat consecutive spaces (delimiters) as one (like excel) to come out with the correct rows. The first row is to be truncated." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-10 : 09:47:39
|
| Read up on DTS, Bulk Insert and BCP in Books Online. Let us know if you get stuck.Jay White{0} |
 |
|
|
|
|
|
dts text import treating consecutive space delim as 1