<sharmauiuc@yahoo.com> wrote in message
news:3fd280f.0312081248.1bbcb963@posting.google.com...
> Thanks for a quick reply. Unfortunately, I am storing word 97, 2000
> as well XP versions.
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
news:<uQC$xYQvDHA.3144@tk2msftngp13.phx.gbl>...
> > Sanjay,
> > Interesting question/request... What version of MS Word (2000, XP or
2003)
> > will you be using? If you're using XP or 2003, you can always save the
> > documents as HTML files and then upload those files into a TEXT column
for
> > easier retrieval. See the "SaveAs Method" at
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd10/html/womthSaveAs.asp
> > for more info on this.
> >
> > I don't think you can read directly from the IMAGE column unless you
want to
> > read byte-by-byte and do the conversion yourself. You might also look at
the
> > newly released XML Schema for the MS Office 2003 file versions that
> > Microsoft has made public at
> >
http://www.microsoft.com/downloads/details.aspx?FamilyID=fe118952-3547-420a-a412-00a2662442d9&DisplayLang=en
> >
> > Regards,
> > John
> >
> >
> >
> > <sharmauiuc@yahoo.com> wrote in message
> > news:3fd280f.0312071008.4a78edcb@posting.google.com...
> > > Hi,
> > >
> > > My platform is SQL2000 Server and Windows 2000 Server. I am using JSP
> > > to retrieve my documents. My FTS appears to be working fine. I am
> > > storing
> > > Word documents (.doc) extension on image column.
> > >
> > > However, I would like to retrieve the word documents content as html
> > > document. Is there a way to retrieve image data and perform on the fly
> > > html conversion using some SQL functions?
> > >
> > > Alternatively, I can create an extra image column and store the
> > > converted WORD
> > > documents into the extra column. I could then retrieve this image
> > > column to display the contents of the word document. However, I would
> > > like this to be
> > > performed using store procedure that will convert word document to
> > > html document automatically.
> > >
> > > Any pointers to perform this work will be highly appreciated.
> > >
> > > Thanks and regards,
> > >
> > > Sanjay