How To Import Excel Dates Into MySQL Using PHPMyAdmin

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn

I tried importing a CSV into PHPMyAdmin, and everything got imported successfully except the date. The date used in Excel is different from MySQL, and number formatting won’t work in this case.

The only solution that I found was to create a new column, and apply this formula to it (assuming column A has dates such as 01/31/2014 in it):

=TEXT(A1,”YYYY-MM-DD”)

This will then allow you to import CSVs with dates into MySQL without any problems.

Similar Posts:

More to explorer

how i started being a minimalist

How I Started Being A Minimalist

Once, I thought that all that mattered in life were the things that you possessed. Things like your car, house, watch, clothes.

Leave a Reply

Your email address will not be published. Required fields are marked *