[AccessD] Getting pictures into a blob in SQL Server

Here is an open source com component dll that will convert gif to jpeg 
etc by first moving image into a byte array
then you just dump the resulting byte array into a blob field.
http://www.imagemagick.org/index.html?




jwcolby wrote:

>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
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada