There's a relatively low-cost ODBC utility called DBScripter that does a
pretty good job creating scripts for exporting ddl and data from ODBC
datasources. It allows you to build dialects for server-based SQL
variations. I don't think that there's a current MySQL dialect, but looks
pretty simple to put one together.
Here's the link to the site:
http://www.dkgadvancedsolutions.com/dbscript.htm
-----Original Message-----
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 10:43 AM
To: mysql users
Cc: Neil Williams
Subject: Re: Licence Free Import/Export for Access?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Neil --
...and then Neil Williams said...
%
% Hi
Hi!
%
% Is there a licence free way to Import (and Export) Access databases (mdb %
files) into (out from) mySQL?
I haven't seen one yet. It's quite possible that nobody has written a file
converter -- also quite possibly because MS hasn't released the file spec
and nobody has reverse-engineered it :-)
I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess
which looks somewhat hopeful; you might dig into that a bit.
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)
iD8DBQE+SnmlGb7uCXufRwARAk5tAJ9AFHohak4IXrL9jhY3suxhWfExvgCgnZvv
X7/gEKohVSZhdAu7N+bTLxo=
=oJMt
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
