Accessing Blob data from access or Excel

Thread View: borland.public.interbase.thirdparty

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by naiem Wed, 13 Jun 2007 11:09

#130

Author: naiem
Date: Wed, 13 Jun 2007 11:09

12 lines
1153 bytes

Hi 

I am trying to extyract BLOB data from an interbase DB for reporting.

The data is stored in blob 0 (binary i think format) but only contains text.

Most drivers/tools do not seem to let me export the Binary blob 

ANy tips VBA code would be appreciated.

Thanks

Re: Accessing Blob data from access or Excel

#131

Author: Craig Stuntz TeamB
Date: Wed, 13 Jun 2007 14:02

15 lines
1679 bytes

naiem wrote:

> The data is stored in blob 0 (binary i think format) but only
> contains text.
> 
> Most drivers/tools do not seem to let me export the Binary blob 

	Try redeclaring the blob as SUB TYPE TEXT. This seems to make a
difference to some drivers/apps.

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio Gonz�lez has a new CD of 
  Irish music out, and it's good: http://tinyurl.com/7hgfr

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads