Copy data from one database to another

[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)

 

[Cor Ligthert [MVP]]

Sijank,

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

Cor

 

[S.M. Altaf [MVP]]

What about

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

Altaf

 

[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