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 |
|
Wezzo
Starting Member
1 Post |
 Posted - 2011-02-16 : 06:14:34
|
| Hi,I have a list of 8000 data items in a Notepad file, one per line. They correspond with 8000 items I have in a table in my SQL server db. I'd like to paste them into a column in that table but, simple as it seems, I can't find a way to do it. Any help?Thanks very much in advanceWesley |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-16 : 08:04:21
|
| What is the structure of the table ?You can use BCP to copy the records from file to table. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-02-16 : 09:21:05
|
| or Use Bulk insertMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Pasting an entire column?