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
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
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
://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
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
: 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
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
<[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
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