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-12-11 : 08:05:09
|
| Ron Lang writes "I have a text file with fixed-width fields. I can't figure how to specify this type of field delimeter in the BULK INSERT or BCP.EXE commands for SQL Server 2000. Can someone give me guidance?Thanks, Ron" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-12-11 : 08:44:14
|
| Hi Ron!You'll have to use a format file, look it up in BOL.The other option is to import everything as varchar(8000) or something like that, and then do some processing in the SQL server to split it up. |
 |
|
|
|
|
|
BULK INSERT and BCP.EXE