title: Data import from Excel to SQL Server failing to import all data
body: <p>I have an odd thing happening with importing data from Excel to SQL Server using the Import and Export Data tool.</p>
  
  <p>The short of it is that I can see the data in Excel, but all of the data doesn’t import.</p>
  
  <p>I have an excel workbook containing one spreadsheet.  I can see the data in the columns and everything looks good.  When I use the import wizard to import the data, I can see the columns and the preview data, but the data doesn’t all get transferred over when the import is executed.  There are no errors and the import process finishes – it just inserts a bunch of null values into the table.</p>
  
  <p>It seems to happen most with numbers – so let’s say I have three columns for first name, last name, and ID number.   I’ll get all of the first and last names, and some of the ID numbers.  I can’t find a pattern for what’s happening.</p>
  
  <p>I had this happen once before and I noticed that there were two spreadsheets to choose from during the import process:  DataImport and DataImport$ - and the first one would fail as described above and the second one would import flawlessly.  This time there is only one spreadsheet to select.  </p>
  
  <p>I’m mainly using an XLS document and the 32-bit import wizard on a 64-bit system, but I’m willing to try anything.</p>
  
  <p>Any ideas of why there are two spreadsheets (sometimes) and why this import would fail?</p>
  
  <p>Dave</p>