title: SQL Server bulk insert command fails importing textfile
body: <p>I am trying to dump the following txt into a table (using the wizard did not work either)</p>
  
  <p><a href="http://download.geonames.org/export/dump/admin1CodesASCII.txt" rel="nofollow">http://download.geonames.org/export/dump/admin1CodesASCII.txt</a></p>
  
  <p>using the following</p>
  
  <pre><code>drop table tempregions
  create table TempRegions
  ( 
  code varchar(500),
  name varchar(500),
  asciiName varchar(500),
  somenumber varchar(500)
  );
  
  BULK INSERT GeoNames 
    FROM 'C:\Users\Administrator\Desktop\geonames\admin1CodesASCII.txt' 
          WITH( 
  
                FIELDTERMINATOR = '\t', 
                ROWTERMINATOR = '\r\n'
  
              ) 
              go
  </code></pre>
  
  <p>getting the following error (using sql server 2012)</p>
  
  <p>Msg 4864, Level 16, State 1, Line 10
  Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (geonameid).</p>
  
  <p>thanks for the help</p>