MySQL time field to MSSQL

[Ravi Nielsen]

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?

Thanks,

Ravi Nielsen
IT Manager
Hunger Mountain Coop