Converting Access to MySQL

[Arc]

Hello guys. I would like to know, is there a simple way to take an access database and put its information into an already existing mySQL database assuming all the tables and fields are the same?

Thanks!😃

[Roger_Ramjet]

If it is a one-off upload then just Export the tables to csv files and use Load Data Local Infile to upload the data, or as featured in phpmysqladmin.

You can use ODBC to open a connection to the Access database and script the queries if it is going to be a regular thing.

MySQL will replicate with itself as will Access, but I don't think you can set up automatic replication between them.

[pheonix]

download a demo of navicat. thats what i did. you get 30days. it does xls and a bunch of other stuff too.