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
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