Access to MySQL?

I have been trying to do this for a really long time now to no avail.

Is there a (relatively) simple way to convert an access database to MySQL?

Can you just export the tables as a csv and import it through MyPHPAdmin?

 

You can export to CSV and then use the LOAD DATA command in MySQL (if your Hoster allows it) but you have to manually create the MySQL tables before you can import the data into them.

There are a number of other options mentioned here: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

 

thanks wootty. +green

my problem is that the tables int he database are long quotes and include quotation marks, tabs and the likes. When I try to export to csv, the csv files don't work right.

I think I will try to delete all commas, quotes and parenthesis before the export.

 

Try MySQL migration toolkit.

 

Only way is, export it to Excel and then use the phpMyAdmin to import it, phpMyAdmin will do it even if your host doesn't allow the Load command.