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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-07-15 : 08:34:33
|
| Hi. I though that i could find a lot of example for this but i got 2 or 3 saying to bulk copy the entry file in an one line temp table and then manipulate the empty spaces.Is this the only way?My file has data like "aaaaa 1212 rrrrr 343434".Thanks. |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-07-15 : 09:00:47
|
| I know the file specs, if that will help:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=195206 |
 |
|
|
|
|
|
bulk insert empty spaces between columns