There is a program at http://www.convert-in.com/acc2sqlp.htm which will
create the MySQL tables from the Access 2000 database and populates
created tables directly from the Access 2000 source. It also converts
date/datetime fields into MySQL format and Yes/No fields into tinyint.
The best news is that it takes about 1-2 minutes to complete the process
{not counting time to load the data}.
One caution, if you have Access queries that reference other queries you
will have to rework the design until MySQL supports VIEWS {currently
targeted for 4.1 according to the manual}.
> -----Original Message-----
> From: Gary Portellas [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 22, 2002 11:46 AM
> To: [EMAIL PROTECTED]
> Subject: Converting Access 2000 to Mysql
>
>
> Hi All
>
> I am new to Mysql / Linux and would like to import my access
> 2000 database
> into a MYSQL database - is there an easy way to do this ??
>
> Thanks
> Gary
>
>
> ---------------------------------------------------------------------
> 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