Get image (picture) from Oracle database
 

Hi there,

I have an Excel file that uses an ADO connection string to connect to an
Oracle database and retrieves the Top 10 selling items for last week. I can
get the style and quantity ok. However, we also have a picture of the item
stored in the Oracle database, and I would like to imbed that picture onto
the excel worksheet, on the same line as the style and quantities.

The Oracle database has one field that defines the image type, and another
field that stores the image.

How does one achieve this ?

Get image (picture) from Oracle database
 

Have some code for this - will post tomorrow when I'm back at work.

Tim


"Gary B" wrote in message
...
Hi there,

I have an Excel file that uses an ADO connection string to connect to an
Oracle database and retrieves the Top 10 selling items for last week. I
can
get the style and quantity ok. However, we also have a picture of the
item
stored in the Oracle database, and I would like to imbed that picture onto
the excel worksheet, on the same line as the style and quantities.

The Oracle database has one field that defines the image type, and another
field that stores the image.

How does one achieve this ?

Get image (picture) from Oracle database
 

hi Gary
can u post the code to connect oracle database using ado?
what reference should i select to run the code?
--
hemu


"Gary B" wrote:

Hi there,

I have an Excel file that uses an ADO connection string to connect to an
Oracle database and retrieves the Top 10 selling items for last week. I can
get the style and quantity ok. However, we also have a picture of the item
stored in the Oracle database, and I would like to imbed that picture onto
the excel worksheet, on the same line as the style and quantities.

The Oracle database has one field that defines the image type, and another
field that stores the image.

How does one achieve this ?