Hello
A SQL 2000 DB of ours contains thousands of photos of our customers' shops stored in image fields
Rec layout is something like rec_id, store_no, image_data
We need to create a cd containing all our photos, and include store_no in the filenames
Could anyone suggest a method for reading through all the pic records and saving them as jpeg files with a filename we specify.
We have c# and MS access at our disposal but a plain old SP solution would be perfect as its just a one off exercise.
Thanks v much
A SQL 2000 DB of ours contains thousands of photos of our customers' shops stored in image fields
Rec layout is something like rec_id, store_no, image_data
We need to create a cd containing all our photos, and include store_no in the filenames
Could anyone suggest a method for reading through all the pic records and saving them as jpeg files with a filename we specify.
We have c# and MS access at our disposal but a plain old SP solution would be perfect as its just a one off exercise.
Thanks v much