MySQL Forums
Forum List  »  Microsoft Access

incorrect Date type
Posted by: CILIA Olivier
Date: October 13, 2005 02:35AM


When I export a MS Access (2002 SP3) table in order to create a table in MySQL (4.1.11), Date type fields in Access are created in Varchar(40) type in MySQL.

Conversely, I create a MS Access link table to MySQL Table. DateTime type fields in MySQL table appear in Text type when i edit the link table.

The connexion between Access and MySQL uses MyODBC

Thank you for your help and apologize my english.

Options: ReplyQuote

Written By
incorrect Date type
October 13, 2005 02:35AM

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.