Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a database which is huge (1.5Gb) because it has files embedded as OLE objects in several tables.

    What I want to do is extract the files from the tables, save them in another folder, and then replace them with a hyperlink. Does anybody have any code to do this, as I would like to do it programmatically as there are over 1000 files to extract.

    Thanks for the help

    Bodders

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See Stephen Lebans' OLEtoDisk.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Brilliant Hans - that is exactly what I needed. Took about 5 mins to run.

    Many thanks

    Bodders

Posting Permissions

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