Home Forums SQL Server 2005 T-SQL (SS2K5) BCP command using TSQL without xp_cmdshell RE: BCP command using TSQL without xp_cmdshell

  • July 3, 2007 at 3:53 pm

    #717013

    there's one other option here but I've never tried it - apparently you can export directly from SQL to Excel using OPENROWSET:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

     

    ---------------------------------------
    elsasoft.org