Get MySQL-Front. It totally rocks. You can export your table from Access into a text file and then import it with MySQL-Front. This program will save you enormous amounts of time if you aren't familiar with using SQL commands. jc -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org] On Behalf Of Tony Crockford Sent: Tuesday, February 12, 2002 4:18 AM To: Thelist at lists. evolt. org Subject: [thelist] Access to MySQL conversion Hi can anyone point me to tried and tested methods/software/tutorials for upgrading from Access to MySQL? (preferably freeware or open source) I found this: http://www.mysql.com/portal/software/html/index.html which is where I found this: http://www.mysql.com/portal/software/html/software_comments-23.html a freeware GUI front end and this: http://www.mysql.com/portal/software/html/software_comments-98.html which in its demo form will create a MySQL database copy of an Access database with all tables (but only 5 records per table - see the above app, which will import the rest!) Just wondered about any others you might have used. TIA -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !