Bug #44916 Date not imported properly from Ms-Excel
Submitted: 16 May 2009 12:04 Modified: 16 Jun 2009 14:03
Reporter: Sanket Porwal Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:5.1.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: date, Excel, load

[16 May 2009 12:04] Sanket Porwal
I am trying to import data from an excel file into mysql database.
The file contains 6 columns (date,open,high,,low,close and volume). The date is of the format dd/mm/yyyy.
Now when i am trying to load the data to mysql by using command
"Load data infile 'c:tcs.csv' into table sample
fields separated by ','
lines separated by '\n';  "

Now using this query data gets loaded into my table but the date value is not the same as it is in excel. for ex:
12/4/2005 in excel
but in mysql

please help me as its very urgent....

How to repeat:
doin at local xampp server....
[16 May 2009 14:03] MySQL Verification Team
Thank you for the bug report. Please verify if the date format in Excel is in the format: 'YYYY-MM-DD' before to export also take a look in the Manual:


Thanks in advance.
[16 Jun 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".