Click to See Complete Forum and Search --> : Transferring Excel, Word, and other documents in a XML structure


Jim Bassett
September 18th, 2001, 09:05 AM
We have a need to transfer documents such as Excel, Word, etc via XML, how does one do that. I am assuming that these would need to be placed into a CDATA section maybe encoding them via BASE64 but I am not sure this is correct or even how to do it. Any code samples, encoding and decoding would be helpful. Also this need includes transferring multiple documents of the types mentioned and that may be a mixture of type of documents, would this cause any problems?

Thanks

Mark Balonkin
October 4th, 2001, 04:00 AM
Our system transfer documents from Word to XML and store it in MS SQL.
There are 2 levers: business object (COM object provide access to database) and VBA lever, which load text from Word and transfer to XML. For this purpose we developed XML format. Format include a lot of tags for store text format, size, font and so on. Special symbol store in tag SS code=xx (xx – ANSI cod).