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 |
|
vishalg
Starting Member
29 Posts |
 Posted - 2009-01-12 : 00:46:48
|
| Hello,I want to copy a word file into a column in a table. But that table has many other column than the one i which i want to transfer the data. Like, the table has different columns as "ID", "Date", "Summary". But i want to copy the word file only into the "Summary" column and the rest of the columns will be manually filled. So does "BULK insert" work in this case too? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-12 : 03:24:46
|
Yes. You can use BULK INSERT, if you have a view that consists of the summary column only. Or a proper format file.Make sure the summary column is IMAGE datatype.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
BULK insert