Migrating from Access to MySQL

I am planning to migrate MS Access database to MySQL because there is much load on that microsoft guy and currently I have about 44 tables in the database and have about same number of forms and reports along with some macros.

I am wondering how can I efficiently work this out so that I do not need to recreat forms again? Does MySQL supports Reports?

Another question, is it possible to retain the formmating when copying data directly from a file like word or something?

Thanks a lot!

access is a frontend+database, but mysql is just a database

you'll have to rewrite all your forms and reports in some other language

alternatively, you can keep the forms and reports in access, move the tables to mysql, and use an odbc connection to get at the tables

as for retaining the formatting of a microsoft word document, are you thinking of copying the data into a tbale?

rudy

Thanks this is what I thought; thanks for explaning it.
Yeah if I decide write a program to read for example MS Excel sheet and enter that data into table. Is it possible to retain the same formating as in Excell or Word. ie, punctuations, font, size, color, etc.

font, size, color? not unless you store it intentionally, e.g. html