Copy data from one database to another

's Computer Specifications

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)

's Computer Specifications

Sijank,

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

Cor

<(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
>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)
>

's Computer Specifications

What about

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

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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)
>

's Computer Specifications

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
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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)
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to copy the data's from one database to another database?	lvensen	Microsoft Access	3	2nd Jul 2009 11:06 AM
how do you copy a database but not copy the data?	=?Utf-8?B?Qm9iYmkgQg==?=	Microsoft Access Database Table Design	1	24th Feb 2005 05:27 PM
copy data from one database to another database	tom	Microsoft Dot NET Framework	1	27th Oct 2003 09:03 PM
copy data from one database to another database	S Gopikrishna	Microsoft Dot NET Framework	0	22nd Oct 2003 07:51 PM
Re: copy data from one database to another database	Girish Bharadwaj	Microsoft Dot NET Framework	0	22nd Oct 2003 02:28 PM