If you can catch hold of a windows box then there is
tool called SQLyog that has a great migration tool.
I was able to import a clients MDB database with all
the FKs directly from Access to MySQL. You dont need
to go thru Access - Script - MySQL.
You can download it from http://www.webyog.com
Perhaps you could try MySQL Migration Toolkit
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
still beta though...
NB!
ATTENTION: Before installing the MySQL Migration Toolkit please download
and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from
http://java.sun.com
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.
Best,
CH
___
Craig Hoffman
www.eclimb.net
[EMAIL PROTECTED]
iChat / AIM: m0untaind0g
___
--
MySQL General Mailing List
- Original Message -
From: Craig Hoffman [EMAIL PROTECTED]
To: MySQL mysql@lists.mysql.com
Sent: Thursday, September 15, 2005 4:52 PM
Subject: converting access (.mdb) files...
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I
Craig Hoffman wrote:
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.
mdbtools: http://mdbtools.sourceforge.net/
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW,