MySQL Bugs: #44916: Date not imported properly from Ms-Excel

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:	None
Category:	MySQL Server: Data Types	Severity:	S3 (Non-critical)
Version:	5.1.22	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	date, Excel, load

Description:
Hi,
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
5/12/2031

please help me as its very urgent....
thanks 
Sanket

How to repeat:
doin at local xampp server....

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:

http://dev.mysql.com/doc/refman/5.1/en/datetime.html

Thanks in advance.

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".