MySQL Forums
Forum List  »  Microsoft SQL Server

MySQL time field to MSSQL
Posted by: Ravi Nielsen
Date: August 19, 2004 12:54PM

We used the Microsoft import wizard to import a MySql database via ODBC. Import completed without errors, however a time field was populated with today's date for all rows. When the same MySQL table is linked to ACCESS, it displays a date also, but varying dates. It appears the neither Microsoft product plays well with MySQL time fields.

Any tips or suggestions on how to make this work correctly?


Ravi Nielsen
IT Manager
Hunger Mountain Coop

Options: ReplyQuote

Written By
MySQL time field to MSSQL
August 19, 2004 12:54PM

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.