Groups > Interbase > InterBase third party tools > Re: Accessing Blob data from access or Excel




Accessing Blob data from access or Excel

Accessing Blob data from access or Excel
13 Jun 2007 04:09:20 -0700
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
Post Reply
Re: Accessing Blob data from access or Excel
13 Jun 2007 07:02:27 -0700
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 
Post Reply
about | contact