View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Hemant_india[_2_] Hemant_india[_2_] is offline
external usenet poster
 
Posts: 107
Default 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 ?