Access to MySQL

zorindart

I've got a site with an authentication system wrote in asp, In this site user's information are loaded in an Access database.
I'd like to convert my site into a php based portal (Joomla), so I need to convert the access database into a MySQL one.
Is it possible? How do I convert between databases?

JustaMin

You can use SQL for both Access (JET) and MySQL, so you should simply be able to simple export the DB contents as a .sql file and import it into mysql.

ml

or you can export the access database as csv (comma seperated values) and import it to mysql via phpmyadmin

kv

if you install odbc driver for mysql, you can import the access tables directly into mysql database opened in access.