[AccessD] Getting pictures into a blob in SQL Server

Jim Lawrence (AccessD) accessd at shaw.ca
Fri Jun 18 00:24:18 CDT 2004


Hi Marty:

The stuff you keep digging up is quite incredible! :-) You are definitely
ascending into the levels of Gustav's research team.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
Sent: Thursday, June 17, 2004 2:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [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



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list