title: Importing Excel into SQL with mixed columns - Large Numbers Contain E+
body: <p>I'm importing an Excel document into a SQL table via the Import Wizard. My table contains many columns and a few of them contain phone numbers, and number/letter identifiers that are rather long (10+ numbers). </p>
  
  <p>Once the Excel document is imported, these numbers get modified. An example: 22222222222222200000 gets stored as 2.22222E+19 in the SQL database.</p>
  
  <p>I've tried formatting the columns in Excel to be strings, general, integer, and etc. but it doesn't seem to matter. When the columns are set to integer, they show the number accurately in Excel, but upon import, they are modified to contain E+.</p>
  
  <p>While uploading, the Import Wizard automatically assumes these columns are "Float," and I've tried altering them to nvarchar as well. The import will still modify the large numbers.</p>
  
  <p>Is there any way to import these values exactly as they appear in Excel?</p>