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

#1 (**permalink**) 28-Jul-2006, 08:23 AM

Dear Readers,

I am intern at an IT company. I have been given a task to extract MS
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11709-exporting-mass-ms-word-excell-oles.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
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 (**permalink**) 28-Jul-2006, 08:23 AM

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" wrote in message
news:1150743047.813471.31230@y41g2000cwy.googlegro ups.com...
> Dear Readers,
>
> I am intern at an IT company. I have been given a task to extract MS
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
> 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.
>

#3 (**permalink**) 28-Jul-2006, 08:23 AM

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
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" wrote in message
> news:1150743047.813471.31230@y41g2000cwy.googlegro ups.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 (**permalink**) 28-Jul-2006, 08:23 AM

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" wrote in message
news:1150746078.652896.22860@u72g2000cwu.googlegro ups.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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11709
> > (no e-mails, please!)
> >
> >
> > "Charles" wrote in message
> > news:1150743047.813471.31230@y41g2000cwy.googlegro ups.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.
> > >
>