If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Threaded View

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.