I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import foreign keys from MSAccess.
Question: If I read properly documentation in MYSql is possible to use only
one foreing key per table, and fields with foreign
To: mysql@lists.mysql.com
Subject: Importing data from MS Access
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import foreign keys from MSAccess.
Question: If I read properly documentation in MYSql is possible
Using a data modelling tool (like Dezign from Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is load the Access
database into the tool, configure the tool to create an export script
for MySQL (say, using InnoDB to enable FKs), touch up as desired, and
generate the
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley [EMAIL PROTECTED] wrote:
Using a data modelling tool (like Dezign from
Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is
load the Access