Copy data from one database to another

13 Nov 2005 1:25 PM

sijank

I m doing a project where i have to transfer data from one database(in
..MDB) to another database ( say.. . mysql). I know we can read the MDB
file and .. prepare SQL and .. run that in mySQL..or some other way..
making intemediate file...

I would like to know is there any better way... directly copying..?

Sijan Khadka
(cZn)

14 Nov 2005 9:58 AM

Cor Ligthert [MVP]

Sijank,

I would go if it is a one time operation as you suggest.

Cor

<sij***@gmail.com> schreef in bericht
Show quote

news:1131888317.528947.143030@g44g2000cwa.googlegroups.com...
>I m doing a project where i have to transfer data from one database(in
> .MDB) to another database ( say.. . mysql). I know we can read the MDB
> file and .. prepare SQL and .. run that in mySQL..or some other way..
> making intemediate file...
>
> I would like to know is there any better way... directly copying..?
>
> Sijan Khadka
> (cZn)
>

14 Nov 2005 2:54 PM

S.M. Altaf [MVP]

What about

SELECT * INTO [C:\Path\abc.mdb] FROM Tablename

Altaf
--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com

<sij***@gmail.com> wrote in message
Show quote

news:1131888317.528947.143030@g44g2000cwa.googlegroups.com...
>I m doing a project where i have to transfer data from one database(in
> .MDB) to another database ( say.. . mysql). I know we can read the MDB
> file and .. prepare SQL and .. run that in mySQL..or some other way..
> making intemediate file...
>
> I would like to know is there any better way... directly copying..?
>
> Sijan Khadka
> (cZn)
>

14 Nov 2005 7:09 PM

W.G. Ryan - MVP

Create two data adapters, one OleDb for the Access db, one for MySql.
configure both of them. Fill a dataset with the Access one. Set
AcceptChangesDuringFill to false before filling. Call update on the second
adapter passing in the *same* dataset as the parameter. Enjoy
<sij***@gmail.com> wrote in message
Show quote

news:1131888317.528947.143030@g44g2000cwa.googlegroups.com...
>I m doing a project where i have to transfer data from one database(in
> .MDB) to another database ( say.. . mysql). I know we can read the MDB
> file and .. prepare SQL and .. run that in mySQL..or some other way..
> making intemediate file...
>
> I would like to know is there any better way... directly copying..?
>
> Sijan Khadka
> (cZn)
>