Help in Inserting Picture (jpg,bmp,etc..) in a table ---- OLE OBJECT
Posted on 2004-08-29
I know this ought to be simple and easy.. and I might need it right away.. who knows what could happen.. :)
I got this database with a table named "users" with ID, NAME, PICTURE as fields
ID and NAME are strings while PICTURE is an OLE Object field...
these are about 100+ records and I got also 100+ jpg pictures in a folder for each user.. How do I put all of those pictures in the OLE Object field (batch) with a VBA procedure/function
and what is the library of ADODB.STREAM.. I cant seem to find it.. (no STREAM option in ADODB)