Converting OLE object (image) field to text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I understand that we should not store images into Access directly as it's not efficient. But I currently have a table that stores the actual image into Access using an OLE object field. I would like to convert this OLE object field into a text field which stores only the path and filename of the image. Does anyone knows how that can be done? I have 1000+ records which i need to convert. Tried looking for a path property of the OLE object but could not find any. Please help

Thanks in advance
yann
 
If the tables now actually contain the images as OLE objects, you will have
to extract them as individual image files, and give them new names, and a
path to store them. It might be simpler to locate the original images used
to create the OLE fields and use them.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
yann said:
Hi all,

I understand that we should not store images into Access directly as it's
Click to expand...
not efficient. But I currently have a table that stores the actual image
into Access using an OLE object field. I would like to convert this OLE
object field into a text field which stores only the path and filename of
the image. Does anyone knows how that can be done? I have 1000+ records
which i need to convert. Tried looking for a path property of the OLE object
but could not find any. Please help!
 
Hi Adrian

Thanks for reply. But may i know how can i extract the images from the table

thanks in advanc

yann
 
Back
Top