Help. I have been working on this for hours. I have to take a table in MS Access and import it to MySQL using PHPMyAdmin "Insert data from a textfile into table" option.
I export the Access table to a CSV file and it gives me all the date fields in the standard Microsoft m/d/yyyy format. When I insert the data all the dates in MySQL are all wrong (example 5/6/1935 becomes 2003-04-20). How can I make this work? I tried formatting it through Access to be yyyy-mm-dd and it shows up that way in the datasheet view, but it exports as 5/6/1935 0:00:00 anyway. Then I tried copying and pasting the records from the datasheet view in Access with the date formating I needed then pasted it into Excel. When I did a CSV of the Excel file I could see the dates in the correct format, but now PHPMyAdmin won't import it correctly. All the fields are out of line etc...
Does anyone have any ideas???
Thanks
