Hi Kha,

I never tried to do this myself but the process seems fairly easy.

Also, if this isn't clear enough, I really suggest to google "access db to mysql" There are plenty of other people that tried it before.

My process was to create the tables in mySQL first, then add an extra field at the end of the list.

I exported the Access table into a Tab deimited text file, then imported the file into the mySQL table. The extra field was to allow for the CRLF chracter which showed up if I didn't use the extra field.

There are some SQLsyntax diffrences you need to watch for. mySQL doesn't support subselects or unions. This caused a little bit of grief at first until I figured out the roundabout syntax. Also, I just discovered another syntax difference with respect to aggregates. select sum(field) as betty worked fine, but this syntax didn't:

select sum(field1) as betty, sum(field2) as suzy, (betty-suzy) as differ.

Nor did this work:

select sum(field1) as betty, sum(field2) as suzy, (sum(field1) - sum(field2) ) as differ

Good luck with your conversion.

Thanks for giving me the instruction but I am still confused and don't have any ideas how to do this yet. I've been using html, asp to build webs before and now I'm just learning php and MySQldatabase. Database is my biggest problem when I'm thinking to change/apply Access to MySQLdatabase.

Thanks
Kha

If you don't know much about Mysql then I suggest you really take a look into that first before converting your database.

The MySQL core training and the Strawberry CMS videos make extensive use of phpMyAdmin to manage your mysql database. I suggest you take a look at those to understand how mysql is working and how you work with it in conjuction with PHP.