MySQL Forums
Forum List  »  Microsoft Access

Exporting Access Table to MySQL - Date Column Conflict
Posted by: ecpcin
Date: February 18, 2005 04:52AM

I exported a table from MS Access to MySQL via MyODBC 3.51.

The result table in MySQL database incorrectly imported a DATE type field as VARCHAR type one and was showing only the year part of the date in the data rows. I changed the field type to DATE but, found that all data in the field to be replaced with "0000-00-00".

Pls advise how to rectify this error.

Rengaraja
The Techie's Tech

Options: ReplyQuote


Subject
Views
Written By
Posted
Exporting Access Table to MySQL - Date Column Conflict
3025
February 18, 2005 04:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.