Correction.....they are stored in the database tables as objects:
INSERT->OBJECT->BITMAP.

-----Original Message-----
From: ROBERTS, Sarah 
Sent: 19 March 2003 10:24
To: ROBERTS, Sarah
Subject: OLE Objects - Export To Excel


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.
_________________________________________________________

Well, maybe you need to think a little harder. I have never done this, but 
surely, Access is taking care of the fact that they are OLE objects. It is 
also handling the associated method for outputting that object. The fact 
that your excel output displays the word bitmap means that there is a 
positive Therefore why not use a code as 1,2,3 in your original query. 
Both Access and Excel use what is known as Conditional formatting. 
Depending upon what value exists in the field, the report, cell, or form 
colour will be changed accordingly. It may be a lot simpler than embedding 
a file?
Regards,

Zak Willis

> Correction.....they are stored in the database tables as objects:
INSERT->OBJECT->BITMAP.

-----Original Message-----
From: ROBERTS, Sarah 
Sent: 19 March 2003 10:24
To: ROBERTS, Sarah
Subject: OLE Objects - Export To Excel


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.
_________________________________________________________