Generate Word Documents from sql server

Question

Generate Word Documents from sql server

midan1

SSCertifiable

Points: 5100
More actions
April 16, 2004 at 10:46 am

#107514

need halp
can i Generate Word Documents from sql server
or
Output RTF-formatted Documents
thnks ilan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

lakusha SSCommitted Points: 1857 More actions · Answer 1

Hi Midan,

I've seen a sp do this with sp_OA procedures. It's ugly and the end result is a Word document, not RTF. You better do this with an external application (VB, Delphi, C++, etc) and not directly with SQL Server. It's a database, not a RAD.

The closest thing would be to use a DTS package with a script or a COM. Theoritically, if you have too much time, you could swallow the RTF specs and do everything from a stored procedure.

sorry, its friday

midan1 SSCertifiable Points: 5100 More actions · Answer 2

hi

this is my problem !

i need to Generate a new Word Documents after the record is insert in sql server table

with new file name ("doc" or "rtf") and in the word docoment i need to write the new user + the record ID +from +date+name+Fname

how can i do this ?

thnks ilan

dongadoy SSC Eights! Points: 880 More actions · Answer 3

Triggers need to be short and sweet to minimized transaction time and blocking. Creating a Word doc definitely does not apply.

Try having trigger add a row to a queue table. Then create a separate program watch that queue table and create the Word doc when a new row appears. That separate program really should be something like VB, VBA, C, etc. It's just very difficult to do that kind of work using TSQL.