Best way to convert Access DB to MySQL?
 

Suggestions appreciatted :winkwink:

cheers

Don't know much about access. With that, I'd export the Access data into a delimited file of some sort (tab, comma), create a mySQL database that matches the schema of the access db and run the mysql "load data infile" command to inject the datafile into the new db.

http://www.websitedatabases.com/access-mysql.html

Import your Access database to MySql, Even if a direct access to your MySQL database is denied.
If you need to import your Access database to a Mysql database to use it in your web site you may find a big problem if your hosting provider doesn't allow Remote connection to his MySQL servers (which is common), but you can always use Access-PHP-MySQL-Magic to overcome such restrictions.

what he said...you can just drop the data in a flat file... (CSV for example)...

if you want a program to do it for you there are several out there...
http://www.convert-in.com/acc2sql.htm is an example

I did this a while back and used a progaram that made it really easy. NOt sure if this is the one but there are several

http://www.convert-in.com/acc2mss.htm

http://www.google.com/search?sourcei...+access+to+sql

Thanks alot people :)