MySQL Forums
Forum List  »  Microsoft Access

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

Hi,

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


Subject
Views
Written By
Posted
incorrect Date type
2551
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.