java method/utility/program for database transfer

[deckdeck]

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

deckdeck

[mnuttall]

Another way is to create a link to the MySQl table in Access and run the query. That should work. I've done it with MS Access and SQL Server. And I think DB2.

But if you have to do it from Java there is an Eclipse plugin for copying databases that are accessable from JDBC - http://dbcopy.sourceforge.net/en/dbcopy/index.html.
I've not use it yet.

[deckdeck]

mnuttall,
i am pretty new in java programming and i dont know how to make links from access to mysql.how did u do it?could you show me some of your codes???and by the way the link you have given me is not workin, i wil try to check it later.
nwy,i rily do apreciate the reply.thanks...

deckdeck

[mnuttall]

http://dbcopy.sourceforge.net/en/dbcopy/index.html

Somehow a period got on the end. Pretty easy to solve.


Links have nothing to do with Java. You do those in Access. Create a new table and do a link.