title: BULK INSERT into SQL Server - using FIELDTERMINATOR
body: <p>I have this query:</p>
  
  <pre><code>BULK INSERT Employee
  FROM 'E:\\file.txt' --location with filename
  WITH
  (
     FIELDTERMINATOR = ' ',
     ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>
  
  <p>And in the my file, the data looks like this:</p>
  
  <pre><code>43266200 6827           43295200 1393/05/23 14:26:26     18      1
  </code></pre>
  
  <p>I want insert this data into my table, but in file in the my fieldterminator have a error and SQL Server complains about space or tab between fields error. How can I solve this?<br>
  can i use this?<br></p>
  
  <pre><code>BULK INSERT Employee
      FROM 'E:\\file.txt' --location with filename
      WITH
      (
         FIELDTERMINATOR = ' ' or '  ' or '        ',
         ROWTERMINATOR = '\n'
      )
      GO
  </code></pre>
  
  <p><br>
  or how can i import this txt file into sql server?</p>