In ASP.Net SqlBulkCopy getting error like The provider could not determine the Double value.
<p>In ASP.Net SqlBulkCopy getting error like The provider could not determine the Double value. For example, the row was just created, the default for the Double column was not available, and the consumer had not yet set a new Double value.</p>

<p>AS using providers as for 2003:<br>
 ExelconnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filname + ";Extended Properties=\"Excel 8.0;IMEX=1;ImportMixedTypes=Text;TypeGuessRows=0;\"";</p>

<p>and 2007 as:</p>

<p>"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filname + ";Extended Properties=Excel 12.0 Xml;";</p>
