How can i easily converse an access database to mysql database?
Access can export schema to various ASCII file types (CSV, XML). various mySQL front ends (like phpMyAdmin) can parse those same ASCII file types.
Sorry...i m a newbie
But in phpmyadmin.. they only way to import a table is with a sql file right??
Or can phpmyadmin import an XML file aswell?
can u explain a bit further? Cheers!
in newer versions of phpMyAdminm, when importing a text file you can choose how fields and lines are terminated, how fields are escaped, and where column names are defined. it's all just a graphical front end to mySQL's LOAD DATA functions.
Try these tools out.
Access2MySQL
MDB Tools
