The *best* way to do this is via conversion software. I find that for table creation and data transfer, http://dbtools.com.br has the best free tool. It converts all your Access and SQL based databases over to MySQL without any hitches. Really good help files and web site as well.
Intelligent Converters also has a good tool, but it's not free (http://convert-in.com) J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]