title: Import Errors from Excel to Access Using DoCmd.TransferSpreadsheet acImport Method
body: <p>I'm getting some import errors when importing data from Excel in to Access.</p>
  
  <p>I'm using the <code>DoCmd.TransferSpreadsheet acImport, ...</code> method to do the import. </p>
  
  <p>The column of data that is failing contains a mixture of number-only entries and strings. It's the string entries that are failing to import.</p>
  
  <p>Is there something I can do to the data in this column of the Excel spreadsheet to ensure it gets across to Access in its entirety?</p>