title: Import data from Excel Wizard automatically detects data types
body: <p>Hello I'm trying to import data from excel file <code>(xls)</code> to new <code>SQL table</code> so I use <code>Import and Export data 32/bit</code> to achieve that. When I load the excel file it automatically detects data types of columns. e.g. column with phone numbers is as data type to new table <code>float</code> and in excel is as Double(15) when I try to change the <code>float</code> to <code>nvarchar</code> </p>
  
  <p>I get this :</p>
  
  <blockquote>
    <p>Found 2 unknown column type conversion(s)
    You have selected to skip 1 potential lost column conversion(s)
    You have selected to skip 3 safe column conversion(s)</p>
  </blockquote>
  
  <p>And I'm not allowed to continue with export.</p>
  
  <p>Is there any way to change the data types when trying to import them?</p>
  
  <p>Thank you for your time.</p>
  
  <p>These data are set as <code>text</code> data type in excel
  Sample data from one of the columns in excel:</p>
  
  <pre><code>5859031783
  
  5851130582
  
  8811014190
  </code></pre>
  
  <p>This is what I get:</p>
  
  <p><img src="https://i.stack.imgur.com/SIth5.jpg" alt="enter image description here"></p>