Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186

    Unanswered: OLE Object extraction

    Hi,

    I have virtually no ms access skills as am an Oracle dba.

    I need to extract OLE Object data which are images from an Access 2000 mdb file for an import I am writing, can anyone point me in the direction of either some software that will do this or any scripts I can write to do this.

    When I open the table the field reads "Long Binary Data"

    Many thanks

    Robert
    Last edited by robert xr4x4; 03-31-06 at 06:27.
    There are 10 types of people in the world, those that know Binary and those that don't.

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by robert xr4x4
    Hi,

    I have virtually no ms access skills as am an Oracle dba.

    I need to extract OLE Object data which are images from an Access 2000 mdb file for an import I am writing, can anyone point me in the direction of either some software that will do this or any scripts I can write to do this.

    When I open the table the field reads "Long Binary Data"

    Many thanks

    Robert
    Import to what ? Oracle or Sql server 2000 ?
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    sorry, I just want to export the files into the file system
    There are 10 types of people in the world, those that know Binary and those that don't.

  4. #4
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by robert xr4x4
    sorry, I just want to export the files into the file system
    We generally do it using BLOB..
    Check this link
    Link
    Hope it will help you.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •