MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Exporting Access Table to MySQL - Date Column Conflict
3031
ecpcin
February 18, 2005 04:52AM
Re: Exporting Access Table to MySQL - Date Column Conflict
2124
Christian Schlepphorst
February 20, 2005 05:12AM
Re: Exporting Access Table to MySQL - Date Column Conflict
2326
surya prakash
March 02, 2005 08:29AM
Re: Exporting Access Table to MySQL - Date Column Conflict
1887
Michael G. Zinner
May 27, 2005 02:16AM
Re: Exporting Access Table to MySQL - Date Column Conflict
1923
Mike Hillyer
June 13, 2005 02:44PM


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.