Thanks everyone for great advice! Tom's question below is also interesting.
Also, are there data compatibility/integrity issues moving from Windows/MS Access to Linux/MySql? I know that Linux is case sensitive and MySql wants dates to be stored as yyyy-mm-dd. Does anyone know of other issues? Thanks again Arthur -----Original Message----- From: Thomas Trutt [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:40 PM To: [EMAIL PROTECTED] Subject: Re: AW: Convert MS Access to MySql question... does anyone know how it sets up the indexes, security preferences , relationships..??? I mean does it do this or does it just create the tables and upload the data??? Thanks Tom T At 06:01 PM 12/22/2003 +0100, you wrote: >Arthur > >Get DBManager Professional (for free) here : >http://www.dbtools.com.br/EN/dbmanagerpro.php > >There is a wizard which can do this conversion for you > >Freddie > > > -----Ursprüngliche Nachricht----- > > Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED] > > Gesendet: Sonntag, 21. Dezember 2003 19:00 > > An: [EMAIL PROTECTED] > > Betreff: Convert MS Access to MySql > > > > I need to convert an MS Access database to MySql. I would > > like to know the best way to do this. I was going to write an > > asp or php script that would read the MS Access db row by row > > and insert into the MySql db row by row. Is that the only way > > to move the data from the one db to the other? > > > > Many thanks > > Arthur > > > > > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Mann Library Cornell University [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]