Converting my Access to MySQL +...

[dror_israel]

Hi,

This is my first attemp with mySQL.
I'm rebuilding my asp+mssql site and doing it with php+mySQL.
what is the best way to convert my db from access to mySQL?

Also, does mySQL have users limit?
I mean how many people can access my mySQL db.

Thanks

[mystrymaster]

I don't know if it would be the easiest but you could simply do a select on the access database and then an insert into mysql.

Or

You could export the access files to text files comma or tab delimited and then use the LOAD data infile sql call.

[jsantama]

I have used the following software. It does the job!

http://www.intranet2internet.com/public/default.asp?PAGE=software&DETAILS=DUMP

I hope this helps.