Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 BCP export with column names

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-20 : 09:54:20
Sam writes "This is probably an easy question, but I cannot find anything in the parameter descriptions that allow it.

I want to bcp out to a text file that will be imported into Excel. The export works fine, but now the client wants to have the column names included at the top of the list. I can do it with DTS with no problems, but can't seem to find a similar command with BCP. (Unfortunately, the client doesn't want to use DTS)

This SQL 7.0 data base on a NT 4.0 server.

Any help would be greatly appreciated.

thanks
Sam
samuelclay@asp-dudes.com"
   

- Advertisement -