How to load an image file into a BLOB in VBA

Hello,

I would like to use Excel with a VBA script and OLE DB to load a list of images into Oracle 8.1.7.

I have a table like this

create table tmp_img (
 EMPNUM NUMBER(10) NOT NULL,
 IMAGE_PIC BLOB
)

and a 10,000 files on disk.

1.jpg
2.jpg
etc...(until 10000.jpg)

For each image, its filename is EMPNUM + '.jpg'

How could I create a VBA procedure to read and insert these images into TMP_IMG ? Thank you,

Denis Received on Tue Jan 28 2003 - 15:02:41 CET