Hi !
> -----Original Message-----
> From: shawn reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 04, 2001 12:50 PM
> To: RCA Webmaster
> Cc: [EMAIL PROTECTED]
> Subject: Re: New member question
>
>
> 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,
> >
Install latest MyODBC driver by downloading from
http://www.mysql.com/downloads/api-myodbc.html. Once installation done, try
to export the table from access to mysql through MyODBC. Please read the
following manual for more details.
http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC
Also there is a " mysqlfront " GUI tool, where in you can directly import
the tables from access (using access DB files) to mysql. You can download
this from www.mysqlfront.de.
Hope this helps you.
Regards
venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
<___/ www.mysql.com
---------------------------------------------------------------------
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