Dear Members, Recently I converted all my MsAccess to MySQL sucessfully. In my opinion, this is a significant step in my swtich over fully to Linux from Windows - a great impediment was overcome atlast. I just wanted to share this procedure with you all - perhaps someone may be struggling in this matter!
1. Download the utility 'mdb2sql' by googling. This tool is simple and effective. 2. Install MySQL in windows and create a database (with same name) as that to be converted. Make sure the nature and size of the fields are (nearly) similar. 3. Run the mdb2sql utility. Since the utility will ask for exisiting mysql database, it is preferable the mysql server is running. The dialog boxes of mdb2sql is selfexplanatory and I hope, I need not elucidate here. (If you want more help, kindly mail me.) 4. Now, we have all the MsAccess databases in WindowsMySQL. I hope, you all know, we can use the MsAccess as a front end to MySQL server (we have to use the MySQLODBC utility here). Here too, if you want more help, kindly mail me. 5. Back up the mysql database (I used mysqldump) and take the file to Linux. There we can restore this database by usual method. BTW, we should have already created (not necessarily tables) the database before restoring. Hope the above procedure is quite explanatory and useful to you all. Happy linuxing! Bye, Rajesh ------------------------------------------------------- This SF.NET email is sponsored by: eBay Great deals on office technology -- on eBay now! Click here: http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5 _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
