Bulk insert issue with date from excel into SQL Table
<p>I am trying to bulk insert these two columns from excel into a temp table ##NBP_Table. However, when I do that I get the following error:</p>

<blockquote>
  <p>'Operand type clash: int is incompatible with date'</p>
</blockquote>

<p>Does that mean the date aren't in the format it should be to be inserted into a table?</p>

<pre><code>create table ##NBP_Table
(
Applicable_Date date,
NBP_Value numeric(4,4)
)

insert into ##NBP_Table
values (01/04/2014,1.7107),
(02/04/2014,1.6482),
(03/04/2014,1.686),
(04/04/2014,1.6681)
</code></pre>