> I will have a look at this page - but anyway, does anybody have
> experiences with importing data from an Access Database file into a MySQL
> DB ?
>
There is an access module on the www.mysql.com site that you can put
in your access database. You run it and it will generate a database dump
that MySQL can read then you can just
mysql databasename < dumpfilename
If you have keys that allow null in Access you may have to change
them so that the tables will be created properly. MySQL will not
allow key fields to be other than "NOT NULL" I usually just
edit the dumpfile and fix the tabledfs before I import it.
Steve
