Monday, March 26, 2012

Images

I have a customer that has several thousand images (bmp) stored in a SQL 2000
database. Is there any way to copy the images programmatically to a folder so
they can be viewed using a photo program? Currently they use an Access form
to display the photos and, needless to say, I don't want to copy and paste
4,000 images.
"Paco" <paco6945@.yahooNoSpam.com> wrote in message
news:24B4FEEE-09C8-47E4-AD53-4F51F00DD284@.microsoft.com...
>I have a customer that has several thousand images (bmp) stored in a SQL
>2000
> database. Is there any way to copy the images programmatically to a folder
> so
> they can be viewed using a photo program? Currently they use an Access
> form
> to display the photos and, needless to say, I don't want to copy and paste
> 4,000 images.
>
It's straightforward to do this using a .NET program. When you select rows
from the table you can retrieve the image column as a byte array and save
each byte array to a file.
David

No comments:

Post a Comment