BCP in MS SQL 6.5

  • How do I actually make use fo the bulk copy program(bcp) to take in my query and export the data in a MS Excel file/format?

    Any help will be deeply appreciated.

  • You cannot use BCP to export to an excel file. However you can generate a CSV (comma seperated value) file which Excel can iterpret. Just specify the file as .csv when you name and use , as the field terminator.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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