I can concur - you pay a little, but you get a much better product with this one.

Ian Zabel wrote:

> 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


---------------------------------------------------------------------
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

Reply via email to