Loading a series of MS Write Docs into MySQL

[erikcw]

Hi All,

I have about 50 MS Write files that I need to load into a MYSQL database. Is there any way to load them in quickly without having to copy/paste the data from each file?

Thanks!

[charlier]

Depends a bit on the details. Do you want to keep them in wirte format or do want to just have text? Are you planning on having one record for each write document or several records (say one per page)?

You can write a script to read the file and insert it into your database.

[erikcw]

It would be one record per document. I need to preferably parse the document title at the top of the page and put it in one DB field, and take the body of the document, and put it in another field.

I just need the text of the document, being in MSWrite format is not important.

Thanks!

[uncle_bob]

If you only have 50 to do, then I'd suggest that the quickest and simplist way is to simply cut and paste. Tedious maybe, but quicker that writing some code to read the files, import the data, debug the code, reimport, forget to delete the old records, delete all the records and reimport again.