Word Document

  • Is it posiable to turn a Word document into an XML so that i can turn the XML into an sql table?

     

    Erik....

    Dam again!

  • Yup. You can also go from florida to antartica then to the north pole and back to Fort Lauderdale to get some milk.

    Or you can save the file on a shared drive and save the path in the db .

  • I have no clue what so ever about the saving to a shared drive.

    I have abut 20 different documents (Word) and thought it would be nice if  i could turn those into table reather than manually entering them into the database. I have to have access to this information via table so that my application may carry out its events.

    To much rain in florida for me, but them againg it rains here and i never know it. IF IT;S not work i never knew it happened. But if you are offering free tickets to Florida, by all means send them on!

    Frequent Flyer,

    Erik....

    Dam again!

  • Shared drive is a folder on a networked computer that every user in the system can read the files. Send the docs there so that you can reopen them at a later time.

  • Word 2003 supports an XML file format - default is still to use a Word XP/2000 .doc format though. The spec for the format has been made public domain

  • Thanks,

    I'll take a look at that..

    Dam again!

  • Do you just want to store the document or are you wanting to query on it. If just to store, you can put in a BLOB field (ntext or image). You will need a front end app or dll to upload it as a stream.

    DBAs tend to be adverse to storing documents in their databases because of the space requirements but you only have 20 so I doubt that that will be an issue and it's more secure in that you can control the database access more easily than a network folder (unless you also are the network admin).

    As you will need a front end to access the documents anyway, it's certainly worth compressing them first if they are of any size.

  • I'd start using XML format now since MS is going to make it the default in the future (.TDOC .TXLS etc.) ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply