Post reply

I want to export the data into excel sheet along with their column names

  • May 7, 2008 at 3:37 am

    #154332

    When I used bcp function the resultset of the query was alone copied into excel file. The column names were not copied.

  • June 4, 2008 at 9:41 am

    #824276

    I think you should have column names in you Excel file to map the column while exporting.

  • June 5, 2008 at 11:57 pm

    #825280

    But if i give column names in the excel file , when i add the data to excel using bcp the column names are overwritten. Is there any way to append data to excel file using bcp?

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

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