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 - 2005-06-13 : 08:30:49
|
| Vikas writes "I have a .txt file. Each data row is of different format ( Each data row contains different no. of column (3 or 4 or 5 or at max 10). I need to import those data in SQL server table in a 10 columns table which is max number of column in text file. How can I achieve the same using BCP utility." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-13 : 09:50:12
|
| You need to use Bulk InsertRefer BOL for more informationMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
BCP file in SQL server with different row format