Displaying OLE Objects retrieved from MS Access

[Raj]

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

 

[K Dales]

-----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 SPAM)@westelcom.com if you want to
pursue this further...