Post reply

Best manner to start MS Excel from SQL Server 2000

  • August 20, 2003 at 1:19 pm

    #101634

    I am thinking just using XP_CMDSHELL to start Microsoft Excel from SQL Server. My co-worker thinks there is a more elegant manner to do this?

    Does anyone here have any ideas as to a better way of doing this?

    Thank you!

    Kevin S.


    Kevin S.

  • August 21, 2003 at 12:14 am

    #470700

    The easy way....ActiveX Scripting.

    The easy way?...sp_OA... stored procedures.


    Joseph

  • August 21, 2003 at 12:45 am

    #470705

    Hi Kevin,

    quote:

    I am thinking just using XP_CMDSHELL to start Microsoft Excel from SQL Server. My co-worker thinks there is a more elegant manner to do this?

    Does anyone here have any ideas as to a better way of doing this?

    if you simply need to start Excel, what's wrong with xm_cmdshell?

    I can't tell, if it's 'elegant', but efficient !

    However, if you need to do something in Excel from within SQL Server, you should use the sp_OA* procedures as fromnaija mentioned

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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