Post reply

How can we open a word document thru SQL server 2005 SP

  • October 12, 2010 at 5:16 am

    #157252

    How can we open a word document thru SQL server 2005 SP.

    Kindest Regards,

    Sarath Vellampalli

  • October 12, 2010 at 5:28 am

    #1235406

    depends on what you want to do with it; the full text engine has the option to open and index the contents of word and pdf documents for example; if you want to open/edit/save the word document(or a copy of it), i think you'd want to use a CLR procedure to automate word, which has a lot of nuances; basically you'd create a word object, open it, do whatever to it,a nd then call teh objects.Save or .Saveas ;

    you can do the same with sp_OaCreate as well;

    a google or two might help turn up some sample code so you don't reinvent the wheel; i haven't done Word or Excel Automation for a while, so Ii don't have any decent examples form SQL, only from vb6 and .NET

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 12, 2010 at 5:32 am

    #1235407

    Thanks lowell

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

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