Convert Access to Mysql

Recommended methods

[ukgimp]

Looking for a good version that does the required. I am wary of trying free software on a security issue, hence my asking for recommendations.

Cheers

[zuko105]

As long as you have them local and enough hd space, access can export csv's and mysql can import them.

You'd have to recreate the structure in mysql first, and they have a pretty sweet client dabase manager that you can download for free.

I use it (mysql) on a few of my db driven sites with cc processing, personal information, etc....

Just be sure and read the docs on how to secure it and ALWAYS set the root password. That's something that most people never do.

Let me know if you need more info and I'll sticky mail it to you.

Zuko

[Storyteller]

You can hook up MySQL ODBC driver and access MySQL tables from within Access. Just be sure to have a primary key and a timestamp column in each MySQL table for this to work properly.

[lorax]

You could do it manually but I'm guessing that's not an option you want to go after.

[ukgimp]

I was thinking of a point and click app like some of the ones below, but I was after a recommendation.

[mysql.com...]

Cheers

[mipapage]

I've been working on this for quite a while now. My client wants a solution that automatically exports data from access to mySQL at a set hour each day.

So far no luck.

However, for simple data migration, I would have a good hard look at myODBC (recommended above). In the process of finding a solution for my clients, I have tried a few point-and-click apps; myODBC was by far the most simple and efficient.

[le_gber]

Personally I use DBTools ( [google.com...] ) , it's a nice freeware and I've been using it for a couple of years now. Works really well for me.

Hope this helps.

Leo