Question on Access to MySQL

[KBowers]

Is it possible to use "Access to MySQL" to export FROM MySQL back to MS Access?

Thanks!

[Kayla]

There are a few ways to dump data from an MySQL database. I think using Access to MySQL software will let you dump the data from the MySQL database if your host allows remote access. Other tools such as phpMyadmin is also a usefull tool to export a MySQL database to a .txt,.csv,.sql file.

[KBowers]

Yes, I'm aware of the ability to export from phpMyAdmin, etc. to a .txt file, etc. but I'm after something that exports DIRECTLY from MySQL to MS Access.

I'm interested in the "Access to MySQL" software only if you can export directly both ways.

Can someone tell me for sure? I'd like to buy this very soon if it will work for me...

[BigFan]

I don't think it will export from MySQL directly back into an ms access.mdb file. It will create a dump file of a MySQL db into a .php or .sql file for backing up your mysql database.