title: bulk insert isn't working reading .txt file into SQL Server
body: <p>I'm using bulk insert to read a text file into a SQL Server table. I keep getting the same error when I try using bulk insert, even though if I take the first line of the text file, and copy the values into a plain old insert into statement, everything works. My database, stop_times, is setup as follows:</p>
  
  <pre><code>train_num int,
  arrival_time time,
  dept_time time,
  station_name varchar(50),
  seq_num, int
  </code></pre>
  
  <p>My .txt file has the following format</p>
  
  <pre><code> 101,'04:30:00','04:30:00','San Jose',1
   101,'04:35:00','04:35:00','Santa Clara',2
   101,'04:40:00','04:40:00','Lawrence',3
  </code></pre>
  
  <p>Running</p>
  
  <pre><code> bulk insert dbo.stop_times
   from 'C:\Users\amanda\Desktop\stop_times1.txt'
   with(
       FIELDTERMINATOR=','
   )
  </code></pre>
  
  <p>Gives me </p>
  
  <blockquote>
    <p>Msg 4864, Level 16, State 1, Line 1<br>
    Bulk load data conversion error (type mismatch or invalid character for the specified    codepage) for row 1, column 1 (train_num).<br>
    Msg 4864, Level 16, State 1, Line 1<br>
    Bulk load data conversion error (type mismatch or invalid character for the specified  codepage) for row 2, column 2 (arrival_time).<br>
    Msg 4864, Level 16, State 1, Line 1<br>
    Bulk load data conversion error (type mismatch or invalid character for the specified  codepage) for row 3, column 2 (arrival_time).</p>
  </blockquote>
  
  <p>etc</p>
  
  <p>However, copying and pasting the first row into </p>
  
  <pre><code>insert into stop_times(train_num, arrival_time, dept_time, station_name, seq_num)
  values (101, '04:30:00', '04:30:00', 'San Jose', 1); 
  </code></pre>
  
  <p>works. I feel like I'm missing something totally obvious in the bulk insert function, but am clueless.</p>