Inserting data from MySQL in .doc file?

Anon

Hello,

I need to insert the data selected from MySQL in existing Word file.
The select query will pull out all news of one newspaper edition, and store them in that file.

If anybody is willing to offer advice or help I would appreciate it very much.

E-mail adress for further corespondence will be also usefull.

TIA,
@

Anon

If you mean a real MS-Word file, you'll need a library or something
that can write in MS-Word format.

Anon

Rich Text Format is well documented enough, you could "roll your own" so to speak for simple documents. Word docs are so non-standard and constantly changing as to be a dangerous format to code to for longevity.

PDF and RTF are two of several choices of more well defined standards you can create pretty easily, and XML might be a nice choice for creation of a table someone can import into a word document via excel or whatever high powered import functions their system had.

We do a lot of tab delimited files for things like palm pilots at work, it's very easy to pump out data like that.

Anon

Ok, what do you think about creating HTML document from MySQL data and importing it in MS Word?

Anon

I'd try it. My guess is that word is good enough at html that if you keep is simple it should work.

paggard

It is very hard to create .doc, but it is possible to create .rtf, which is known by Word.

I have the script written, and have only good references from the people who use it.

If you're interested, you can test the script on-line:
http://paggard.dlight.ru/rtf_gen/

or send me a letter : paggard@dlight.ru

best regards.