Link to home
Start Free TrialLog in
Avatar of Richard Coffre
Richard CoffreFlag for France

asked on

import xlsx file with dates with phpmyadmin

Hi all,

I want to import data from an xlsx file containing dates (see the file attached log.xlsx) in a MySQL db.

I join a snapshot of my webserver configuration (server-config.png) .

Thanks in advance.
log.xlsx
server-config.png
ASKER CERTIFIED SOLUTION
Avatar of gplana
gplana
Flag of Spain image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of TWHARRIS
TWHARRIS
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard Coffre
Richard Coffre
Flag of France image

ASKER

The problem is to import properly the date to have date fields in MySQL.

Any ideas ?
Avatar of gplana
gplana
Flag of Spain image
I think it should work if MySQL fields are date data type, and also your local configuration (on the server where MySQL database is) fits the configuration on your Excel File.

I also think this link may help: http://stackoverflow.com/questions/6671877/how-to-keep-the-datetime-format-from-csv-to-mysql-database-when-importing-data
Avatar of Richard Coffre
Richard Coffre
Flag of France image

ASKER

I will test all the solutions tomorrow.
Then I will rank them.
Avatar of gplana
gplana
Flag of Spain image
No problem. Let us know if it works.

Regards.