Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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 ?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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 ?



  #3   Report Post  
Posted to microsoft.public.excel.programming
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 ?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Downloaded from Oracle Database Sarah at DaVita Excel Discussion (Misc queries) 0 January 30th 07 06:11 PM
conection with Oracle database ashishprem[_19_] Excel Programming 3 May 25th 06 05:57 AM
How to get data from Oracle Database to Excel? David Willis New Users to Excel 1 March 31st 06 01:57 PM
Oracle database login Tim Reid Excel Programming 1 September 12th 05 04:35 PM
SQL.Request from Oracle Database CraigRhino Excel Programming 1 February 25th 04 10:33 PM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"