Convert doc to Html to database coln thru lateBinding
Posted on 2002-05-29
I am trying to convert an Word doc to Html and this Html's source code is read and put in sql database column(ntext datatype).
I had few problems trying to do this, but purchased the code from EE. I guess the accepted code was of "Richie_Simonetti" of date 08/03/2001 10:29AM
The problem is as follows:
1)First of all, the code works fine if i give a "Reference" to the Word object library, and then use the word object to open a doc file, and "SaveAs" html file.
After I save the doc as Htm file, I give reference to filesystem and text stream to read the html file and insert into my database 'ntext' column. The reason I am stressing on 'ntext' datatype is because anything other than 'ntext' does not take the formatted doc fike, like bold, the colors, tables etc. That's why 'ntext'
But my machine has Windows2000 Professional configured so in my source code i had referenced word 10.0 library.
And my clients are all using Word 97, so there is this problem of 'version conflict'
So I thought of using 'late binding' which took care of the version conflict, put was not converting the doc to html in the proper way(I could see all junk, small boxes)
2)Second is my clients may have in their doc files some images, like charts and pie diagrams, so when I convert this doc to html it creates a separate folder(with images as it always does if you save as html).
I was wondering if sql database has a datatype which will hold text, formatted text and 'images' as in this case.
Am I on the right track, any info, help would be apprciated or maybe a workaround.
Here's the synopsis:
-how to late bind because of version conflict,
-convert it into proper html format without junk,
-and third if at all images are there in the doc file, what is the workaround.