bcp format file

  • I am trying to export data out of a table.  Here's a section of the format file:

     

    6 SQLCHAR 0 1 "\",\"" 6 MODEL1 SQL_Latin1_General_CP1_CI_AS

     

    Basically, data in model1 it is an empty field.  But when the export runs, it makes the value " ", with a space in between the quotes.

    I verified the space does not exist in the table.  What can I do to fix this?

     

     

  • anyone have any ideas or suggestions?

     

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

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