Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to load an image 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 - 13:55:30 CST