How To Import Excel Dates Into MySQL Using PHPMyAdmin

//How To Import Excel Dates Into MySQL Using PHPMyAdmin

How To Import Excel Dates Into MySQL Using PHPMyAdmin

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:

By |2014-08-22T00:47:39+00:00August 22nd, 2014|Programming & Code|0 Comments

About the Author:

Alvin Poh lives in Singapore, and is interested in marketing, techy stuff, and likes to just figure out how the two can work with each other. He can also be found on Google+.

Leave A Comment


*