List:General Discussion« Previous MessageNext Message »
From:Karam Chand Date:January 12 2005 7:22am
Subject:Re: Importing data from MS Access
View as plain text  
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.

Karam
--- 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.
> 
> 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/mysql?unsub=1
> 
> 



		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 

Thread
Importing data from MS AccessPaun11 Jan
  • Re: Importing data from MS AccessPeter Brawley12 Jan
    • Re: Importing data from MS AccessKaram Chand12 Jan
RE: Importing data from MS AccessBob)12 Jan