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 |
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 2006-11-22 : 17:35:10
|
| Hi guru'sI have a task in hand of bulk inserting into a table. i have data in txt formate and have to insert this data into table. Please tell me the step by step procedure for this task.thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-22 : 18:13:53
|
lookup "bcp utility" in the BOL index.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-22 : 19:03:08
|
You can use DTS, BCP or BULK INSERT. All method is well documented in Books OnLine. Please refer to it.
KH |
|
|
|
|
|
|
Bulk insert from txt file