Home » SQL & PL/SQL » SQL & PL/SQL » Export BLOB file in Excel (10g)
Export BLOB file in Excel [message #572019] Wed, 05 December 2012 07:34 Go to next message
vikasarorait
Messages: 9
Registered: August 2009
Junior Member
Hi ,

I want to export the data from oracle with BLOB column in excel file.

BLOB file contains the Image (jpg)

Please help me.

Thanks in advance.

Regards,
Vikas
Re: Export BLOB file in Excel [message #572022 is a reply to message #572019] Wed, 05 December 2012 07:49 Go to previous messageGo to next message
cookiemonster
Messages: 11076
Registered: September 2008
Location: Rainy Manchester
Senior Member
excel isn't really a great format for holding binary data (jpg in this case).
Do you want the image to appear as in an image in the xls?
Re: Export BLOB file in Excel [message #572024 is a reply to message #572022] Wed, 05 December 2012 07:54 Go to previous messageGo to next message
vikasarorait
Messages: 9
Registered: August 2009
Junior Member
Yes I wan to export the image in excel column with test other data for that record
Re: Export BLOB file in Excel [message #572028 is a reply to message #572024] Wed, 05 December 2012 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think you can do this.
But you can query Oracle database from Excel using VBA and OO4O, OLEDB, ODBC... (although I'm not sure ODBC supports Oracle BLOB, OO4O does anyway).

Regards
Michel
Re: Export BLOB file in Excel [message #572066 is a reply to message #572028] Wed, 05 December 2012 13:58 Go to previous messageGo to next message
vikasarorait
Messages: 9
Registered: August 2009
Junior Member
Thanks Michel, I have to think another way around to store the image file in DB and read it.
Re: Export BLOB file in Excel [message #572451 is a reply to message #572066] Wed, 12 December 2012 02:56 Go to previous message
dbtoolsme
Messages: 1
Registered: December 2012
Junior Member
Export img to file,and use other script to insert into excel.
Previous Topic: Question on savepint
Next Topic: Need Function/sql query
Goto Forum:
  


Current Time: Sat Oct 25 11:17:01 CDT 2014

Total time taken to generate the page: 0.09516 seconds