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 |
|
kpsqlteam
Starting Member
6 Posts |
 Posted - 2009-09-10 : 07:52:16
|
| How to load single column data into table from text file in SQL server 2005...Thanks for help |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-10 : 08:00:45
|
| You can use BCP or the Import/Export Wizard. |
 |
|
|
kpsqlteam
Starting Member
6 Posts |
Posted - 2009-09-10 : 08:06:32
|
| Yes I can use BCP, but using BCP u can copy all the columns into the table. I want to load only one column data into the table...it would be help ful if you provide the SQL for the same |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-10 : 08:10:17
|
| To ignore other columns, you need a format file with BCPHere's an example: http://technet.microsoft.com/en-us/library/ms179250.aspx |
|
|
|
|
|
|
load the data