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)

Sijank,

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

Cor

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

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 quoteHide quote

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 quoteHide quote

Add New in Bindings Navigator problem
Inserting Access Table from VB.Net
getting Identity value back
ORM Frameworks for Visual Studio 2005
DataGridView Update
Getting Identity back
Parameter Limitations with ADO.NET?
Subprocedure for Oracle's SET DEFINE OFF command
Fill data in Excel table
Adding external data into database data before it is sent to Control (Repeater, Datagrid, etc.)