title: Import error for large negative numbers from CSV to Access using TransferText
body: <p>I'm importing data from a CSV file into an Access table.  The number is something like<br>
  -21000000 (-2.1E7).  I'm using TransferText to do the import.</p>
  
  <pre><code>DoCmd.TransferText acImportDelim, , "matching report temp", Source_folder &amp; "\" &amp; Source
  </code></pre>
  
  <p>In the "matching report temp" table, the field is set up as Double.  The import generates a type conversion failure.  However, when I open the CSV file in Excel and copy the offending row, I can successfully use Paste Append to add it to the table manually - so the number doesn't exceed the capacity of the field.</p>
  
  <p>As far as I can tell, this only happens with large negative numbers.  Smaller numbers, and positive numbers of the same magnitude seem to import fine.  I know I can specify an Import Specification in TransferText, but I don't see a way to set the field type to Double.  </p>
  
  <p>How can I get around this problem?  I don't want to have to manually track down the import errors and append them by hand.</p>