Export Data in Excel Using BCP Command

  1. declare  
  2. @Str varchar(8000)  
  3. begin  
  4. set @Str='bcp MisTest.dbo.Tmp_Details out "D:\Tmp_Details.xls" -c-ServerName-U Vithal-P pass'  
  5. print @str