Re: Convert MS Access to MYSQL

2004-01-30 Thread Matthew Stuart
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote: There was some discussion in December of converting MS Access databases to Mysql and the DBManager program was recommended. I have recently converted access to mysql. I used access to import a CSV file and ensured all data was in

Convert MS Access to MYSQL

2004-01-30 Thread kc68
There was some discussion in December of converting MS Access databases to Mysql and the DBManager program was recommended. I have DBManager running and select "Tools=>Data Management=>Import/Export Wizards," but the command is greyed out and won't activate. I am using Office 2000 and I have m

RE: AW: Convert MS Access to MySql

2003-12-22 Thread Arthur Klimowicz
ssues? 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 , relation

Re: AW: Convert MS Access to MySql

2003-12-22 Thread Thomas Trutt
://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

AW: Convert MS Access to MySql

2003-12-22 Thread Freddie Sorensen
003 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 inser

RE: Convert MS Access to MySql

2003-12-22 Thread Matt Lynch
: Sunday, December 21, 2003 11:00 AM To: [EMAIL PROTECTED] Subject: 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

Re: Convert MS Access to MySql

2003-12-21 Thread Martin Gainty
Arthur On converting data from MS Access. I've done this several times myself, and found the easiest way is to: 1. Create your mySQL database tables 2. Define a DSN (ODBC Connection) from your workstation to the mySQL database 3. Link the mySQL tables into your MS Access database 4. Copy the conte

Re: Convert MS Access to MySql

2003-12-21 Thread jamie murray
<[EMAIL PROTECTED]> Sent: Sunday, December 21, 2003 2:30 PM Subject: 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 an

Convert MS Access to MySql

2003-12-21 Thread Arthur Klimowicz
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 th