I have used dbScripter a lot for this kind of work. It is definitely NOT necessary to own Access to use it. One of its nice features is its database profiles. These function as data and syntax translation tables. For example, if a column type doesn't exist in the target, substitute another column type. It only took a small amount of experimentation to create a MySQL profile, and using that I have frequently moved databases from SQL 2000, Oracle and Access to MySQL. dbScripter will work fine with virtually any ODBC-compliant back end. Hth, Arthur
-----Original Message----- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: February 12, 2003 10:45 PM To: mysql users Cc: j.urban; Christensen, Dave Subject: Re: Licence Free Import/Export for Access? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave & J, et al -- [re DBScripter and urSQL] Those are nice tools, but if I read you correctly they only work if one has MS Access. The original poster, if I read *him* correctly, wants a way to read Access DB files and turn them into MySQL files -- but without having to have MS Access. That would be my desire if I ever had to touch an MS Access file, since I don't have Access almost don't run Windows at all. Did I misunderstand anyone? HTH & TIA & 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+SxTLGb7uCXufRwARAhvNAKCDaezt+gSN4BQinKadUoWzvw2wWACg5hrn apGMD7+rA8vIqlbp2ZkBS4Y= =N2rx -----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