The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in access that mysql didn't like, and the import would fail), I got a perfect copy of my access database into MySQL.
http://www.convert-in.com/acc2sql.htm -----Original Message----- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access->mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php