title: SQL Server Import from XLS cant convert Double to int/bit
body: <p>So I exported an sql database out as an excel file so that I could send it off to be edited by hand. I used the <code>Microsoft SQL Server Management Studio</code> then the <code>SQL Server Import and Export Wizard</code> to do so. Now the edits are finished and when I go to reimport the file I get</p>
  
  <pre><code>Found 7 unknown column type conversion(s)
  You are only allowed to save the package
  </code></pre>
  
  <p>And it wont let me run the import. It seems to me as though the export to excel converted all <code>int</code> and <code>bit</code> datatypes into <code>Double</code> datatypes and It doesn't know how to convert back. I did a bit of googling and I found the <code>SSIS10ToMSSQL.XML</code> file (which appears to control how the conversion takes place), but I don't know how I should edit it to tell the wizard how to convert correctly.</p>
  
  <p>Any input on this problem would be appreciated.</p>