none
Read "long binary data" from Access DB? RRS feed

  • Question

  • Hello,

    I have data in access table that is the type of "OLE Object" (long binary data), How do I read this long binary data from the access table? Thank you so much
    N/A
    Thursday, March 5, 2009 3:34 AM

Answers

All replies

  • Here is an example how to work with BLOB data

    http://www.codeproject.com/KB/database/AccessBlob.aspx
    Val Mazur (MVP) http://www.xporttools.net
    Thursday, March 5, 2009 11:05 AM
    Moderator
  • Thank you VMazur for the information,

    Now, I would be able to read the long binary data from the access table and save it in the text file but the data I have is not a bitmap or jpeg, it is the RTF data string with all the RTF format in it.   Is there a way to convert the RTF format string to a readable format and write out to the text area in aspx page? 
    In web application VS2005, it doesn't have the "RichTextBox" control tool for you to write the Rich Text Format string to it. Is there an alternate way to convert the RTF string to a readable text format?

     Sample of RTF string:

    {\rtf1\ansi\deff0\deflang1033 {\fonttbl{\f0\fmodern COURIER NEW;}{\f1\froman\fcharset2 Symbol;}{\f2\fswiss Arial;}{\f3\froman Times New Roman;}}{\colortbl\red0\green0\blue0;}\f3\fs16\cf0 {\par\par DETAILS NOT AVAILABLE


    N/A
    Thursday, March 5, 2009 8:42 PM
  • I believe you would need to use some sort of third-party component to view RTF content. If I am not mistaken, Infragistics has one that allows viewing rich-text content


    Val Mazur (MVP) http://www.xporttools.net
    Friday, March 6, 2009 11:11 AM
    Moderator