title: How do I bulk insert from an excel file that does not have the same columns as the table?
body: <p>I have an excel file with data for these columns: ID, Name, Phone Number. But the table in SQL also takes the address - which isn't in the excel file. This is causing the following error:</p>
  
  <blockquote>
    <p>Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for column address</p>
  </blockquote>
  
  <p>If I remove the address column from the table in SQL Server, I do not get this error upon import. I am ok with the address field being blank after import.</p>
  
  <p>Here is my SQL for import:</p>
  
  <pre><code>BULK INSERT tableName FROM filePath
  WITH (
  Datafiletype = 'char',
  Fieldterminator = '\t',
  Rowterminator = '\n',
  Firstrow = 2
  )
  </code></pre>
  
  <p>I am using SQL Server. </p>