bcp Utility

• Karthika Raman

  SSCrazy

  Points: 2520

  More actions

  May 1, 2006 at 3:35 pm

  #117417

  Hi,

  I am trying to output the query results to an excel file on the LAN.

  I get a usage error message as follows when I try this statement through the QA.  I don't know what parameters/Arguments I am missing.

   

  usage: bcp {dbtable | query} {in | out | queryout | format} datafile

  This is the statement I am using

  exec master..xp_cmdshell 'bcp "select * from Database.tableName" queryout

  \\UNCPath.xls -c -S ServerName -T'

   

  Any help is greatly appreciated

  KR

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  May 1, 2006 at 10:09 pm

  #635245

  Just a guess, because I'm not at a place to try it out, but the UNCname may need quotes.

  ---

  And then again, I might be wrong ...
  David Webb