Displaying OLE Objects retrieved from MS Access
 

Hello all,

I have a MS Query in Excel filtering and retrieving
relevant data from MS Access. When the data returns, all
BUT the column which refers to a OLE object datatype in
Access returns values.

What should I set the format in Excel to see the OLE
objects dynamically.

Thanks

Displaying OLE Objects retrieved from MS Access
 

-----Original Message-----
Hello all,

I have a MS Query in Excel filtering and retrieving
relevant data from MS Access. When the data returns, all
BUT the column which refers to a OLE object datatype in
Access returns values.

What should I set the format in Excel to see the OLE
objects dynamically.

Thanks

.


Hmmm, haven't tried this and not sure if it is possible.
Although you can imbed or link an OLE object into Excel
manually, there is no "Format" for a cell to display an
OLE object.

The only thing I could think might work would be to use
VBA code (with ADO) to build and run your query, then to
transfer the resulting values to your worksheet and
programatically insert the objects as you go.
Complicated, though, and not enough time/space here for
getting into details.

Email me at kgdcc(NO if you want to
pursue this further...