April 22, 2002 at 9:50 pm
I am quite new to SQL Server and am in need of some help!!
I have a SQL2k database with a table that I want to insert
images into :-
photos table
------------
parcel (int)
photo (image)
I also have photos (jpgs) for each parcel with the same
name as the parcel (ie file 34567.jpg will be for
parcel 34567).
Can someone help with inserting the JPEG files into the
photos table using the parcel as the filename? I would like
to do it all at once and not do each one separately.
Basically I want to insert the contents of each JPG file into
the photos field where the filename=parcel(with .jpg on the end).
Hope someone can help.
Thanks
Paul
April 23, 2002 at 7:59 am
Try BII.exe. It's installed under SQL Server\....\DevTools\Samples\Utils.
Andy
April 25, 2002 at 6:55 am
You could use Textcopy? I created a stored proc a while ago that called textcopy thru xp_cmdshell. Then I write a VB app that matched the image file names with a name in the database table and cycled thru the contents of a directory kicking on textcopy along the way thru an ADO connection.
Worked well, although was semi slow.
Andy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply