Hey guys and gals. I've been looking for some time now about converting an access database to a mysql database. Are there any tools or PHP codes that can help me out?
Hey Mr. Class, welcome back! How about using the free utility Access To MySql , it is quite powerful and easy to use. Hope that helps, good luck :)

Edit: Other options include:

DRPU Database

You can also follow this tutorial.
4 days later
Thanks Ayman. I hope it doesnt mix up for records written in Arabic
18 days later
I personally use mdbtools, a command line utility for Linux. It does pure magic :)
Ok I have another issue here... What if you want to build an application where you want to allow your users to upload their data in a spreadsheet (pre-defined by you) and then have the info go to your MySQL database? How do you parse data inside a spreadsheet using PHP?
Your task is easy, but you'll probably need to read a tutorial. PHP and MySQL work amazingly together. As a matter of fact, PHP's popularity is due to it's perfect work with MySQL.

A quick overview:
PHP offers many functionalities to connect to MySQL.

You have some native functions with 'mysql_' prefixes. They're obsolete and depreciated.
New versions of these functions are prefixed with 'mysqli_'. They're a lot more recent, and take advantage of the full power of mysql.

And finally, you have PDO, an abstraction layer supported natively by PHP (though it could be deactivated). This is definitely the way to go, for mainly two reasons:
* It is clearly put forward since PHP5, and there is a clear effort from PHP developers to make it the only way of connecting to db in future versions.
* Inserting an abstraction layer, will make it extremely easy should you one day decide to change from MySQL (to Oracle, MS SQL or even the super awesome cool PostgreSQL). You should know by now, how important it is for a developer to create something as maintainable as possible.

So what I would recommend is that you Google :"PHP PDO tutorial". If you're already comfortable with PHP it shouldn't take you long to understand it :)

As usual, have fun coding :)
Yup I'm actually very comfortable with PHP but I've never heard of PDO before lol. It's really good to know that the PHP guys introduced an abstraction layer. I should check that out. Usually, when I think about scalability I try to abstract things as much as possible. Rather than creating a "Database" class, I would create a "MySQLDatabase" class and include all the logic which is tightly coupled with MySQL inside it. This way, I could easily create an "OracleDatabase" class and so on. But to be honest, I never had to work with anything other than MySQL when using PHP. I heard about PostgreSQL before but I never felt like I actually need it with MySQL already available to me.

EDIT:

@rahmu: In case you read the question I asked, do not answer it. I will start a new thread which should be interesting...

To everyone interested about PDO read this great tutorial
Ok Mr. Class so I think you know who I am :P
Use a program called AccesstoMySQL pro, I used it and it's perfect.
Tell me on MSN if you want it, I'll host it on my server.

<admin edit: post cleaned – read the writing guidelines>
Hey yo abedjoud. Sup man? Thank you all for your replies. I found an application called Navicat. Its a pure wonder. You can use it to even connect to a remote database. You guys should try it out.