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:sandeep.murphy@stripped]
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 <mysql-thread126539@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-ian=ezabel.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
