|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy data from one database to anotherI 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) 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) > 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) > 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) > |
|||||||||||||||||||||||