MySQL Forums
Forum List  »  Microsoft Access

Re: Exporting Access Table to MySQL - Date Column Conflict
Posted by: Christian Schlepphorst
Date: February 20, 2005 05:12AM

What version of MS Access are you using?

I got the same problem with Access 2000 on a test system under XP Home. (Field of VARCHAR(4) is created containing only the year.)

On a second test system with Access 97 under Windows 2000 Server it transfers the data correctly, but to VARCHAR(40). Linking the table back to Access it gives TEXT(255).

When I try to follow the advice of Mr. King-Turner in the thread 'cannot modify data in my "mysql" db via "Ms Access 2003" ' and manually change the data typ in MySQL to DATETIME, for me it still links back to TEXT(255). Moreover, I can't change the field data from Access (ODBC error).

Has anybody a hint to get the table links for DATETIME fields correctly? If we don't get this working, we will have to resort to MICROSOFT SQL Server :-(

Best Regards

Christian Schlepphorst

Options: ReplyQuote

Written By
Re: Exporting Access Table to MySQL - Date Column Conflict
February 20, 2005 05:12AM

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.