PC Review


Reply
Thread Tools Rate Thread

Convert Oracle BLOB to MS Access text

 
 
Chris
Guest
Posts: n/a
 
      2nd Oct 2003
Hi,
I would save the BLOB objects out to the filesystem and
only maintain a table with the associated information,
including filepath, in your Access application.

The other way would be to use SQL server or MSDE as your
backend database in an Access project application. Then
you can use BLOBS.

HTH
Chris

>-----Original Message-----
>I have a trouble ticketing application that saves off
>attachments in an Oracle BLOB field. When it saves off

the
>binary information it places a text header of a User ID
>and a DateTime stamp.
>
>I want to take and parse out the BLOB headers into a
>seperate MS Access table with the header saved in a text
>field limited to 256 characters.
>
>For the first trial I have been searching for a way to
>parse the BLOB information into multiple text rows in
>Access just to get started but cannot find an effective
>example of reading in multiple rows of Oracle BLOB and
>saving off as many more rows of smaller MS Access text.
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Oracle Blob and access 2003 Clif McIrvin Microsoft Access 0 3rd Nov 2009 07:16 PM
jpeg from oracle blob in access report =?Utf-8?B?cmV0?= Microsoft Access External Data 1 5th Jul 2004 10:37 AM
Re: Convert Oracle BLOB to MS Access text TC Microsoft Access Macros 1 7th Oct 2003 07:28 PM
Re: Convert Oracle BLOB to MS Access text TC Microsoft Access VBA Modules 0 1st Oct 2003 07:56 AM
Re: Convert Oracle BLOB to MS Access text TC Microsoft Access External Data 0 1st Oct 2003 07:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:11 AM.