there are a number of ways you could accomplish this.
depending on how large the database is, you may want to try exporting it
to csv (comma separated value) format, and then importing it into mysql,
using either the "load" command, or a third-party utility like phpmyadmin
(which is what i generally use for tasks like that).
another way is if you are indeed using php and you have odbc support
compiled in... you could simply read from the access database and
simultaneously write it to a new mysql table.
that's what i could think of offhand..someone else out there might have a
better solution or three. =)
~shawn
On Sat, 4 Aug 2001, RCA Webmaster wrote:
>
> I have just subscribed to this list, so forgive me if my question has been
> answered many times before but I was not sure where else to find this
> information.
>
> I am new to mysql and am going to be using it on a website that I maintain.
> My question is, is there a program/utility or easy way to convert an MS
> Access database to mysql format?
>
> Thanks,
>
> Chris
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01
>
>
> ---------------------------------------------------------------------
> 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
