migration

While on the fag end of a project for the MIT course, for which I had used MySQL throughout while the rest of the participants had preferred Oracle 9i, MS Access and even 10g (what's with the browser driven control?) I finally sought and found an easy way to migrate all my tables from Access to MySQL. More on the 9i2MySQL migration later, but here are the steps for the Access2MySQL migration:

1. Export the data from Access to a .csv file [mytable.csv]
2. Place this file, say, in D:\
3. Fire up mysql query browser (or get it and then fire it up :)
4. Create the table [mytable] in the appropriate database (more on this step later)