Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Exporting mass MS Word and Excell OLE's to seperate MS Word and Excell files from Access 97 DB

Discussion in 'Information Technology' started by Charles, Jul 28, 2006.

  1. Charles

    Charles
    Expand Collapse
    Guest

    Dear Readers,

    I am intern at an IT company. I have been given a task to extract MS
    Word and Excell files, stored as OLE's in a MS Access 97 database.
    There are several hundred files, so I was wondering if there was a way
    to automate a process to extract them into one directory. They need to
    be in there own prospective files and formats (.doc and .xls). Thanks
    in advance.
     
  2. Loading...

    Similar Threads Forum Date
    1984 Sikh Massacre - A Documentary History of Sikhism May 28, 2016
    Cant believe its Chistmass Blogs Oct 17, 2015
    Movies Ashdoc's movie review---Black mass Theatre, Movies & Cinema Sep 24, 2015
    URGENT PLZZ HELP: KAAM LUST BODY MASSAGE SPA ISSUE Sikh Youth Jul 9, 2015
    Events Nankana Sahib Saka (massacre) - Infographic History of Sikhism Feb 26, 2015

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Take a look at what Stephen Lebans has at
    http://www.lebans.com/oletodisk.htm

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Charles" <FrostyXE@gmail.com> wrote in message
    news:1150743047.813471.31230@y41g2000cwy.googlegroups.com...
    > Dear Readers,
    >
    > I am intern at an IT company. I have been given a task to extract MS
    > Word and Excell files, stored as OLE's in a MS Access 97 database.
    > There are several hundred files, so I was wondering if there was a way
    > to automate a process to extract them into one directory. They need to
    > be in there own prospective files and formats (.doc and .xls). Thanks
    > in advance.
    >
     
  4. Frosty

    Frosty
    Expand Collapse
    Guest

    Dear Mr. Steele,

    Thank you very much for the link. Would you happen to know of a similar
    tool for SQL 2K? My supervisor just realized that the files were moved
    to SQL 2K database.

    - Charles Hilton

    Douglas J Steele wrote:
    > Take a look at what Stephen Lebans has at
    > http://www.lebans.com/oletodisk.htm
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Charles" <FrostyXE@gmail.com> wrote in message
    > news:1150743047.813471.31230@y41g2000cwy.googlegroups.com...
    > > Dear Readers,
    > >
    > > I am intern at an IT company. I have been given a task to extract MS
    > > Word and Excell files, stored as OLE's in a MS Access 97 database.
    > > There are several hundred files, so I was wondering if there was a way
    > > to automate a process to extract them into one directory. They need to
    > > be in there own prospective files and formats (.doc and .xls). Thanks
    > > in advance.
    > >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You could try creating a linked table and see whether Stephen's application
    will work with that. Otherwise, I'm afraid I don't know of any application
    to do the same with SQL Server.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Frosty" <FrostyXE@gmail.com> wrote in message
    news:1150746078.652896.22860@u72g2000cwu.googlegroups.com...
    > Dear Mr. Steele,
    >
    > Thank you very much for the link. Would you happen to know of a similar
    > tool for SQL 2K? My supervisor just realized that the files were moved
    > to SQL 2K database.
    >
    > - Charles Hilton
    >
    > Douglas J Steele wrote:
    > > Take a look at what Stephen Lebans has at
    > > http://www.lebans.com/oletodisk.htm
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Charles" <FrostyXE@gmail.com> wrote in message
    > > news:1150743047.813471.31230@y41g2000cwy.googlegroups.com...
    > > > Dear Readers,
    > > >
    > > > I am intern at an IT company. I have been given a task to extract MS
    > > > Word and Excell files, stored as OLE's in a MS Access 97 database.
    > > > There are several hundred files, so I was wondering if there was a way
    > > > to automate a process to extract them into one directory. They need to
    > > > be in there own prospective files and formats (.doc and .xls). Thanks
    > > > in advance.
    > > >

    >
     

Share This Page