Migrating from Access 97 to Mysql

[AntiThesis]

For some strange reason someone thought it would be a grand idea to use Access 97 for one of our purchasing databases. This is now changing and I need to import it into MySQL.

I've begun to use MySQL Administrator for this task but it seems to only grab the tables and structure and doesn't insert any rows. When it is doing the bulk data transfer it says that x amount of rows are being done but there's nothing in there.

Any clues?

 

[reech]

try: http://www.mdbtomysql.de/

 

[AntiThesis]

Ta reech. Will give it a go.

 

[simple_simon]

you couldn't picked a better time to migrate from a decade old software package

 

[AntiThesis]

If I'd had my choice it never would have been created in the first place

And just to add to my fun the thing is riddled with erros and mistakes. Hooray.