SQL Table...need RTF exported to word

[StephHansen]

I have a table called FILES. In it are the columns, file_id and content (the RTF content). I would like to export all of these into individual word docs (or rtf if word can't be done) that are saved as their file_id followed by the appropriatye extension. ie-13227.doc.

I am using SQL 7.0.

Any advice on how to do this? Thanks so much! I appreciate the help!

Stephanie Nicholas
Software Engineer
NetSetGo, Inc.

 

[joebickley]

Hi

i dont know how you could do this directly from a sql server but if you wrote something in access or VB to do it it might be easier

for access Just link the tables to it write a report to display the data and then use a bit of code to export the report to rtfs for each record. Just shout if you want to know how

thanks

joe