View Single Post
Old 11-02-07, 11:53 PM   #10
ephmrl
Registered User
 
Join Date: Dec 2006
Posts: 81
Default Re: Conversion of word files into XML and then extracting to an Oracle database

Quote:
Originally Posted by MUYA
Thanks bud, but is there another easier way? erm rater than covert straigh to XML, erm extract to the database maybe?
Sounds like you should just write up/macro record some vb script to export your word tables to simple CSV (comma seperated values), or tabs, or colons, etc files, and then import those to whatever database you are using. This would avoid the need for the xml converter at least. Presuming you are using access, your vb script should be able to easily launch both word & access, and iterate through your files without manual intervention.

Good luck.

Here's a few links that describe the basic manual steps:

http://word.mvps.org/FAQS/TblsFldsFms/WordToAccess.htm
http://www.brainbell.com/tutorials/m...s_Database.htm
ephmrl is offline   Reply With Quote