How can I export OLE objects from an Access table to Excel?

[MarkC]

I have a field in access that contains a picture (OLE Object). When I export
an access table to excel, everything is exported but the object field is
empty. Is there a way to do this automatically without any fancy
programming? Also, I have problems doing this in reverse to - that is import
a picture into access from excel. Any advice?

 

[John Nurick]

Hi Mark,

There's no way of doing it without fancy programming. I suspect it would
be very fancy: you'd need to calculate whereabouts on the Excel sheet to
put each picture so it would stay with the record it belongs to.

 

[MarkC]

Thanks for your response. How about in reverse - i.e. from excel to access?

 

[John Nurick]

Equally fancy programing would be required. Access's built-in routine
for importing from Excel assumes that the data is in a contiguous block
of cells, and grabs the values that Excel has stored for each cell. It
doesn't see graphic objects on the worksheet, so your code would have to
somehow work out which item in the worksheet's Shapes collection went
with which row of data, then get the picture out of the Shape and into
the Access OLE field.

 

[MarkC]

Thanks again - I'm afraid that my worst fears have been realized.

 

[John Nurick]

If you can give a higher-level description of what you want to achieve
there may possibly be a simpler way of achieving an acceptable result.