I'm trying to use bcp to export a view to excel. It's quite simple, except I would like to place the column names (or even manually specify) the excel column headers.
Can this be done on a simple export, or must I use a template, and if so how's it done?
Thanks!