Update mysql from Excel
Posted: Wed Jun 22, 2011 2:40 pm
I have an Excel file with a date column that looks like this -- 6/13/2011 9:43:24 PM.
I can use Excel_reader to conver the Excel file into an array and then extract the date field.
I want to use getDate to extract information like day of the week etc before posting to a mysql file.
I have tried many different ways, but can't seem to get the correct commands to be able to use the getDate function.
Is this possible?
I can use Excel_reader to conver the Excel file into an array and then extract the date field.
I want to use getDate to extract information like day of the week etc before posting to a mysql file.
I have tried many different ways, but can't seem to get the correct commands to be able to use the getDate function.
Is this possible?