Easiest way to convert Access database to MySQL?

Question

What is the easist way to convert an Access database to MySQL. I do not want to use any software to convert the database. Thanks.

There ARE other ways to do it aside from software. If you don't have a solution, please don't post.

Thanks Dylan!

Answer 1

you can check out the limk below it will help you alot

http://www.webthang.co.uk/tuts/tuts_dbase/convert/convert.asp

Answer 2

I haven't done it with MySQL, but if I were approaching this to do with an Oracle database, I'd look to export the records in a delimited text file (would caution using "," as the delimiter unless you know that it isn't a character in your records). Once you have the delimited file, you can use a control file to enable loading from the text file. I don't know if MySQL has that though but I'm guessing it has something similar.

Another option that should work if you are handy with some light programming is the use of ODBC drivers and coding to move your data. I have seen ODBC drivers for both MS Access and MySQL before.

Answer 3

unsure, in case you could convert an get right of entry to database to mySQL yet i'm particularly confident Hypertext Preprocessor can no longer tension MS get right of entry to. now and lower back they might yet assume a great form of subject concerns. or you need to use ODBC.

Answer 4

I'm afraid that you will need some type of software solution. However, if you just mean FREE, then SQLYog will do it. They have a free community edition that is really nice:

http://www.webyog.com/en/downloads.php

Once you install it, go to Powertools menu and select Migration Toolkit. Just follow the wizard.

Jeff
http://www.quizextreme.com

Answer 5

I hate to say this but you need software to convert it.

RJ