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...
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL