<div>
ok, I see what's wrong with row 289 now. <br />
That cell is 3/13/2003 (mm/dd/yyyy) but got changed to 13/03/2003 and SQL Server simply doesn't accept month 13. What should I do now?
</div>


ok, I see what's wrong with row 289 now.
That cell is 3/13/2003 (mm/dd/yyyy) but got changed to 13/03/2003 and SQL Server simply doesn't accept month 13. What should I do now?

<div>
In my case it's:<br />
DateFormat dfSource = new SimpleDateFormat(&quot;dd/MM/yy<wbr />yy&quot;);<br />
DateFormat dfTarget = new SimpleDateFormat(&quot;MM/dd/yy<wbr />yy&quot;);<br />
<br />
but I got your point. And it's working. Thanks a lot.<br />
<br />

</div>


In my case it's:
DateFormat dfSource = new SimpleDateFormat("dd/MM/yyyy");
DateFormat dfTarget = new SimpleDateFormat("MM/dd/yyyy");

but I got your point. And it's working. Thanks a lot.



<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I am using JExcel to read data from an excel file published on the web and put it in our internal database. One of the columns in the file is date of format (mm/dd/2003). I do something like:<br />
String theloaddate = null;<br />
theloaddate = cell[0].getContents();<br />
then I write &quot;theloaddate&quot; to a temporary csv file and bulk insert the file to a database table.<br />
<br />
I got a SQLException as below:<br />
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 289, column 1 (LoadDate).<br />
<br />
I checked the temporary file and found the format of &quot;theloaddate&quot; column somehow got changed to dd/mm/yyyy which is fine, but I just can't see what's the problem with row 289. It looks exactly the same with any other rows.<br />
<br />
Please help. Thanks.
</div>
</div>


Hi:

I am using JExcel to read data from an excel file published on the web and put it in our internal database. One of the columns in the file is date of format (mm/dd/2003). I do something like:
String theloaddate = null;
theloaddate = cell[0].getContents();
then I write "theloaddate" to a temporary csv file and bulk insert the file to a database table.

I got a SQLException as below:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 289, column 1 (LoadDate).

I checked the temporary file and found the format of "theloaddate" column somehow got changed to dd/mm/yyyy which is fine, but I just can't see what's the problem with row 289. It looks exactly the same with any other rows.

Please help. Thanks.

JExcel date format

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.