How to insert a value in Image column of a table ?

Dear all,

In SQL server 6.5/7.0

I have bitmap file called pic123.bmp. it is available in c:pic123.bmp.

I have a table called pictb -- columns picid int, picval image.

How i insert the c:pic123.bmp file into picval column of pictb table.

Image columns only takes value of varbinary.....


How can i do that....? Please give your suggestions.....

Wincy

hi Wincy,

I got the same problem. I will appreciate if you help me with solution if you got from any one

You can use Textcopy utility.

http://www.databasejournal.com/featu...SQL-Server.htm