mm3project

I want to move my MS-ACCESS database to MySQL

Get everything right in ACCESS.

create a new MODULE in ACCESS.

copy this script and paste it into the module

make the following changes:

search for "\g" and replace it with ";"
search for "c:\temp\esql_add.txt" and change the drive letter to a drive that you can write to
search for "c:\temp\esql_del.txt" and change the drive letter to a drive that you can write to

Now place your cursor within the function
"Function exportSQL()"

and press the RUN/PLAY button on the toolbar.

This creates the 2 txt files mentioned above.
Open the esql_add.txt file and copy the contents

Then in MySQLAdmin
paste into the SQL window

Press GO

it will recreate all the tables, indicies, etc and insert all the data into the tables into your MySQL database.

posted by thebigblaa @ 12:34 p.m.