Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: OLE Objects - Export To Excel


Message #1 by "ROBERTS, Sarah" <Sarah.ROBERTS@w...> on Wed, 19 Mar 2003 10:14:55 +0000
Dear All,

I have a table which stores bitmap images (red, green & amber circles -
traffic lights!).

The bitmaps are stored as OLE objects.

Queries pick up the bitmaps and all reports show the actual bitmap picture.

However, I need to be able to export the report to Excel. This is where the
problems begin..

The report exports and Excel displays all fields except the bitmap field
which is blank.  A colleague had a go and managed to get Excel to display
the word "Bitmap", but obviously this is no use whatsoever!

Any ideas?  This one has me stumped...

Thanks for any help

Sarah


_________________________________________________________
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
_________________________________________________________


  Return to Index