title: Bulk insert on specific columns in sql server
body: <p>is there a way to execute bulk insert on a specific columns, i.e. if the column number of the file don't match with the column number of the table.</p>
  
  <p>I want to import a file with the following schema :</p>
  
  <pre><code>Customer_ID,Customer_Name,Customer_Adress
  </code></pre>
  
  <p>in 'Customer' Table having the following schema:</p>
  
  <pre><code>Customer_ID,Customer_Name,Customer_Adress, Customer_Phone,Customer_email
  </code></pre>
  
  <p>is it possible?</p>
  
  <p>Thanks</p>