Re: Importing Access into MySQL
| From: | Joseph H Blythe | Date: | Fri, 08 Dec 2000 00:54:22 +0000 |
| Subject: | Re: Importing Access into MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-29270@lists.php.net to get a copy of this message | ||
On Fri, 8 Dec 2000 10:40:40 +0900
Maxim Maletsky <maxim.maletsky@japaninc.net> wrote:
> >
> >Yes you can, after you create the tables and field types..
> >
> >DBTools will import all the tables and field types into a pre-existing
> mysql database.
>
> mySQL database doesn't really have to be a "pre-existing" one. an
> Access .mdb file is itself a database and when converting it with DBtools
> you have an option to whether choose an existing mySQL database or create a
> new one.
>
> Cheers,
> Maxim Maletsky
>
>
> >In the past I have always just replicated the access database in >mysql
> then as you suggest export the data from access in csv and import it into
> mysql, that was until I was put onto DBTools which can save me alot >of time
> :-)
> >
> >Regards
> >
> >Joseph
>
Hmm, yes i forgot about that :-)
cheers
Joseph