I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
--- Peter Brawley <peter.brawley@stripped> 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
> 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 script.
> Paun wrote:
> >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 key must be on ordered
> >on the same way in booth tables, and only in InnoDB
> type of tables.
> >I have tables with many foreign key connectons
> (e.g. members / streets,
> >members/occupations, members/state of membership)
> between tables, and it was
> >easier way to keep data in database in proper order
> with less programing. Is
> >that is not possible in MYSQL?
> >Of course, I am very new in MYSQL.
> >No virus found in this outgoing message.
> >Checked by AVG Anti-Virus.
> >Version: 7.0.296 / Virus Database: 265.6.9 -
> Release Date: 1/6/2005
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!