RE: [PHP] Importing Access into MySQL
| From: | Maxim Maletsky | Date: | Fri, 08 Dec 2000 01:37:29 +0000 |
| Subject: | RE: [PHP] Importing Access into MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-29265@lists.php.net to get a copy of this message | ||
be careful though about field names.
If while transforming an error occurs it won't stop. The only way to see
that will be only software's error log.
You should first make a copy of access file and check there carefully all
the field names. Then transform it into mySQL and play with column
properties. Who usually makes access databases has all the fields f...ed up.
So be aware: it is not like: click-a-button-and-it's-done, you'll have
restructure lot's of things over there.
But there's no easier way to do it. And DBtools is easy enough to use.
(sometimes it crashes, but still is OK)
This is what I am playing with whole this week.
Cheer,
Maxim Maletsky
-----Original Message-----
From: Joseph H Blythe [mailto:joe.blythe@binarylogic.com.au]
Sent: Friday, December 08, 2000 6:40 AM
To: David Smith
Cc: php-general@lists.php.net
Subject: Re: [PHP] Importing Access into MySQL
On Thu, 7 Dec 2000 12:58:39 -0500
"David Smith" <webmaster@indywebdesign.com> wrote:
> Anyone know where I can get info or tell me how to import an access
database
> into a MySQL db?
>
> David Smith
>
>
DBTools is a windows program which can do just this, I have used it and it
works, you can find it here:
http://dbtools.vila.bol.com.br/
hope this helps,
Regards
Joseph
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net