Date conversion from Access to MySQL

[belocin]

Hi
I exported an Access table into txt - comma delimited file, to Load into a MySQL table. Everything works except the Date/Time field from Access. MySql fills the field with 0's wheter I use Date, DateTime, or timestamp. Can anyone help with this? or is there a way to convert a varchar to an actual date? [sig][/sig]

 

[Sina]

Try sqlporter from realsoftstudio.com.

It can covert Access and Micrsoft Sql server database and schemas to Mysql very nicely.

 

[CPUburn]

hi,

try Mysql-Front !!

it's free and comes in VERY handy: you can adress an access db directly or by an odbc datasource, it reads data and table structs and produces a .sql file on the fly

grtz
CPUburn