Post reply

BCP

  • June 8, 2006 at 8:28 am

    #94260

    Hi guys,

    I am using BCP to export data to excel files. I am wondering if its possible to add different tables as sheets in a single excel file rather than creating a new excel file for each table?

    Thanks

    Shams

  • June 8, 2006 at 4:15 pm

    #642672

    When you say BCP I am assuming that you mean the BCP.exe command line utility.  You won't be able to specify a sheet using BCP.exe, however if you use DTS and define your destination connection as MS Excel 97-2000 you can set your data destination to a specific sheet in a specific workbook.

    Jason

    -

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

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