World Wide Tutorial

A very common case, as in my case, to start using MySQL, you need to migrate my database from Access to MySQL. The solution to this problem gives us a module created by Pedro Freire Cynergi.

The steps you must follow to install the module, and its subsequent use are:
Open the file in Access. Mdb file you want to export.
In the window object from the DB select "Modules" and then "New."
Then it will open a new window, delete any text (code) that you have written.
Copy the entire text of Pedro Freire file and paste it into the new module.

Close the code window for the module, which selects "Yes" to save changes and appoints the module (eg "MexportSQL). The module is now part of your Access database
Reopen the form, or click the mouse on "Design" with our new module selected. Move the cursor to show where the first word "Function" and press F5 or select Run from the menu.

The implementation of the module we will create two files (esql_add.txt and esql_del.txt) in C: / temp (which comes by default, but you can change). For us the file we are interested in is esql_add.txt, which appears to us as best we llevarnoslo to our Linux box.

Now we just have to follow the step explained in the previous chapter:
1.Create the database: mysqladmin create mybd
2.We flew the data and the new database: esql_add.txt cat | mysql mybd