RE: [PHP] Importing Access into MySQL
| From: | Maxim Maletsky | Date: | Fri, 08 Dec 2000 01:40:40 +0000 |
| Subject: | RE: [PHP] Importing Access into MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-29266@lists.php.net to get a copy of this message | ||
>
>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