[Resolved] Access to MySQL (and vice versa)

[piersk]

Can anyone recommend a good piece of freeware/open source software that can convert from an Access database to a MySQL database (and preferably vice versa)?

Ta muchly people.

[goldbug]

Dunno if Access has a tool like this.... but If you had an ODBC connection to MySQL, I would hope that Access could puke data at it. Dunno tho, never tried.

[piersk]

I've tried that, but am having problems because the MySQL server is remotely hosted (however, I do have admin access to the computer).

[goldbug]

Last I checked, it shouldn't matter if the MySQL is remote. At one time I was testing/developing an ASP (yes, I know, bleh) site at home, and had the site running off my girlfriend's windows box, but using data off the MySQL server on my FreeBSD box. IIRC, it doesn't matter if its local or not, you just gotta be able to reach port 3306 of wherever it's located 🙂

[barand]

Piersk

Thers an excellent addin for access called MyAccess. Links to MySQL db's and makes it a doddle to transfer. Look it up on Google.

hth

[piersk]

Bumpity bump!

Does anyone know of a way to take the .sql file that has been exported from a MySQL db and open it in Access?

[LordShryku]

Access' SQL is pretty nasty. Might want to try in Access, under tables, do New->Import Table. Could work...

[stolzyboy]

there is a program called access2mysql, but it is $35 that will convert access to mysql and vice versa

[LordShryku]

Everytime I've needed to do this, I did what goldbug explained. Just connect via ODBC and use a make-table query

[stolzyboy]

there is also a tool called EMS MySQL Manager here