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 > 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. > > PB > > 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. > > > >Thanks. > >-- > >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: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
