July 15, 2005 at 7:24 am
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!
July 15, 2005 at 7:27 am
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 .
July 15, 2005 at 7:34 am
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!
July 15, 2005 at 7:57 am
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.
July 18, 2005 at 4:16 pm
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
James Horsley
Workflow Consulting Limited
July 18, 2005 at 4:19 pm
Thanks,
I'll take a look at that..
Dam again!
July 19, 2005 at 2:00 am
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.
July 25, 2005 at 12:55 pm
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