1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

upsizing ms access 2K to mysql problems

Discussion in 'Linux & Open Source' started by yoda, 16 May 2006.

  1. yoda

    Hitman

    Joined: 18 Oct 2002

    Posts: 858

    Location: Cheshire

    ok, two problems....

    1) When exporting from access to ODBC source (system dsn to linux mysql server allready setup and known working) it comes back with the error "OVERFLOW" on some tables. The table I'm trying to upload is 80mb (access). Aparently the tables have some sort of corruption that the access repair can't find????? anyone have eny info on this?

    2) To get around problem 1 I exported the table as CSV and then imported it into blank table usin PHPMYADMIN. however it has a problem with the dates, access uses / for date seperator and it looks like mysql uses -. basically even if I change the /'s to -'s it still only puts 00-00-00 for the date.

    Any help on these two problems appreciated...

    Thanks