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.

The Techie's Tech

Options: ReplyQuote

Written By
Exporting Access Table to MySQL - Date Column Conflict
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.