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

[wincy]

Dear all,

In SQL server 6.5/7.0

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

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

How i insert the cic123.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

[bimal]

hi Wincy,

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

[skhanal]

You can use Textcopy utility.

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