java method/utility/program for database transfer
to all geniuses out there,
does anyone here know a java program that would transfer my MS ACCESS2000 tables to MYSQL?i already know the easy way which is by exporting,what i need is a java program that will do this.i already have done a program that will transfer a mysql database to another mysql database,the problem is i cant do it from msaccess2000 to mysql.i simply cant get the right sql statement to do it.
>select * into sample from login;
*sample is the database from mysql*
*login is the database from msaccess*
i cant figure out a way so that the tables from the login database(msaccess) will be transfered to sample database which is in mysql.
any site or example will be highly appreciated...