[dba-SQLServer] Getting pictures into a blob in SQL Server

jwcolby jwcolby at colbyconsulting.com
Thu Jun 17 07:55:48 CDT 2004


I got a call from someone yesterday needing to get 25000 pictures into a
blob field in SQL Server.  The program he is attempting to use apparently
stores the pictures it uses in such a field.  These pictures are currently
stored as GIFs (I believe) on the hard drive.

I can write a program to cycle through a dir on the disk, but would I just
read the text into a string and dump it into the field, save and move on?
Has anyone ever done this?  

I included AccessD in this request as I am guessing I'll just do it through
VBA in AccessD.

John W. Colby 
www.ColbyConsulting.com





More information about the dba-SQLServer mailing list